Viewing 15 posts - 3,511 through 3,525 (of 4,080 total)
Thank you, sir. 🙂
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 8:11 am
I have colleagues who use GROUP BY clauses without aggregation in place of a SELECT DISTINCT. The results appear to be the same. I've always used a DISTINCT if I...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 8:10 am
Thanks, Arun.
Almost missed the EXISTS in the first line. I'm going to test both and see if there is any significant difference.
Jeff's version appears to be slightly...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 7:50 am
I once shot an elephant in my pajamas... how he got into my pajamas, I'll never know.
I see a little silhouette-o of a man
Scaramouche! Scaramouche!
Will you do the fandango?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 9, 2009 at 7:46 am
Good deal, Ed 🙂
Quick question, after you do the pivot, are you having to do another step to group the various IDs into a single string, or are you joining...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 8:09 pm
That's what we're looking for, only one of the two queries runs based on EXISTS test.
Thanks, Jeff.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 7:26 pm
I've been trying in vain to think of a good image so I can market "ThreadHead" t-shirts.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 6:48 pm
You don't like "Bohemian Rhapsody", Bruce?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 3:30 pm
BismilLAH!... NO! It will not let you go! 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 2:37 pm
The security would be implemented on the AS400 side. So have a chat with the AS400 admin. If it is like SQL server, they would create an...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 2:34 pm
Nelson, could you please be specific about "the desired results?" We really have no idea of what you are trying to accomplish. ...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 2:27 pm
I know of no syntax for a "null row". Either one or more rows are returned, or they aren't, and @@Rowcount is the way to...
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 2:00 pm
You cannot die, McLeod.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 1:24 pm
FLASH!
AhhhhAhhhhhh
Savior of the universe.....
Gail, do they have the "Inspector Gadget" cartoon over there? I find that tune flushes everything else out.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 11:52 am
Yes.... I speak of Him Who Must Not Be Named !! :w00t:
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
March 8, 2009 at 11:13 am
Viewing 15 posts - 3,511 through 3,525 (of 4,080 total)