Don't stop him, Gail. He's on a roll. I'm taking notes....

But don't worry, Jeff. You guys and gals who truly know what you're...

Sacrilege!!

Heresy!!

There can only be One!!

I think I need to go take my meds, now...

All hail The Thread... Eternal is The Thread... Great is The Thread... Mighty Mighty is The Thread.

Let us make great sacrifice of cursors and recursive CTEs....

Why do I suspect that we're slowly being led to a point where he wants us to solve an actual problem at work, rather than just a general rant as...

Can we just take this one off the fire? It's obviously done. If anyone cares, he posted the exact same rant over in the MS forums...

Owch, I forgot all about that. You're exactly right, Jack. Good save, and thank you.

The thread is definitely worth reading in it's entirety, because the...

Thank you, sir. Good job, and good night.

Hey Bruce,

If they're going to go that far, why not just help write some front-end editing and leave the db out of it? Or is this a...

If you're going to do that, Steve, you should also edit the subsequent posts where people quoted him.

You are correct that you have to define the columns in advance for PIVOT. This isn't a problem for [storeName], but it is for [itemName] because your...

Here is the code I should have posted earlier.

-----------------------------------------------------------------------------------------------

-- code to generate temporary sample data table for testing purposes

-----------------------------------------------------------------------------------------------

declare @words table (wordID int primary key, word varchar(20))

insert into @words

select...

I believe Mangal stated at some point that his primary area of expertise was BI, however, he enjoys SQL. He likes CTEs. SELECT statements make...

Sounds like you're good to go then. I was just throwing out ideas about a few "gotchas" I ran across the first time around. Looks like...

Stick with your RBAR animation. It's extremely cool.

This is...

It should work well for you.

Do you have some sort of convention for distinguishing those databases which should be queried from others which shouldn't? You can...