Viewing 15 posts - 241 through 255 (of 4,080 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. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 9, 2016 at 6:27 am
What version of SQL is the production system running?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2016 at 7:11 pm
Other general performance enhancing features that are not legal for Olympians.
SOM 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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).
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2016 at 9:00 am
You're very welcome. 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2016 at 8:29 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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
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....
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
September 8, 2016 at 6:43 am
Viewing 15 posts - 241 through 255 (of 4,080 total)