Viewing 15 posts - 241 through 255 (of 4,079 total)
It's a good practice to go through every new release and read up on what new functions have been added. Lots of pleasant surprises to be found. ...
September 9, 2016 at 6:27 am
What version of SQL is the production system running?
September 9, 2016 at 6:24 am
If any of you carnivores haven't tried "lacquered" bacon, you're missing a treat!
Edited to add:
You can't divide by zero...
You can't divide by zero...
You can't divide by zero...
You can't divide by...
September 8, 2016 at 7:11 pm
Other general performance enhancing features that are not legal for Olympians.
SOM 😀
September 8, 2016 at 7:10 pm
The reality is the largest usage of databases is within the business sector.
Well yes it is. Are you asserting that that the other members of this forum...
September 8, 2016 at 7:06 pm
Yev, in this instance a CROSS JOIN would have produced the same result.
I just don't make it a practice to join to subqueries (ctes, derived tables).
September 8, 2016 at 4:38 pm
I agree with Chris and Gail.
Every one of those emails are going to result in a "WHY DID THEY KILL MY JOB?" scream.
September 8, 2016 at 11:11 am
You're right, Drew. If he's just using it to filter by, there is no need for the join.
In fact, if the original Date_Xref is indexed on date, unique...
September 8, 2016 at 11:02 am
Looks like it works to me, Drew.
I'd vote for your solution based on the compactness of the code. 😀
September 8, 2016 at 10:32 am
Peter, thank you for bringing this to my attention. I'm not sure how that happened but there is no excuse for it. For some reason SSC...
September 8, 2016 at 9:00 am
If I may restate the problem:
You want to hold any invoice that had a remaining hold amount prior to the invoice, whether or not the invoice itself exceeds the hold...
September 8, 2016 at 7:30 am
If I may restate the problem:
You want to hold any invoice that had a remaining hold amount prior to the invoice, whether or not the invoice itself exceeds the hold...
September 8, 2016 at 7:29 am
Thanks, guys.
Jo Pattyn: Yes you could and in practice you would. Use of the constants just made the examples more readable for purposes of this...
September 8, 2016 at 7:10 am
There is a potential problem right up at the front. The codes starts with a "Date_Dataset" cte that does a SELECT DISTINCT to produce a list of values....
September 8, 2016 at 6:43 am
Viewing 15 posts - 241 through 255 (of 4,079 total)