Hey Gail and Steve,

Please understand, I wasn't suggesting anything as strenuous as the peer review my friend has to go through. I was just trying to draw...

Thank you, sir. 🙂

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...

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...

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?

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...

That's what we're looking for, only one of the two queries runs based on EXISTS test.

Thanks, Jeff.

I've been trying in vain to think of a good image so I can market "ThreadHead" t-shirts.

You don't like "Bohemian Rhapsody", Bruce?

BismilLAH!... NO! It will not let you go! 😀

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...

Nelson, could you please be specific about "the desired results?" We really have no idea of what you are trying to accomplish. ...

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...

You cannot die, McLeod.

FLASH!

AhhhhAhhhhhh

Savior of the universe.....

Gail, do they have the "Inspector Gadget" cartoon over there? I find that tune flushes everything else out.