Oh, I understand what you want to do... but why do you want to do this to perfectly good data? Why do you need all of 1 person's info...

Now I remember... it's called "Parameter Sniffing" and, apparently, it can crush otherwise effecient code. Lots of good info on the Web about it... Google it...

Of course it's going to take some time... your sproc has four relatively large SELECTS and they ALL must be recompiled even if only one is going to be used...

The...

Ummmm.... you know what SUM is... do you know what COUNT is?

I've never understood this... a 300GB hard drive costs about $110 and a 500GB hard drive costs only about $140. Your database is going to do nothing but to...

Very urgent normally means "I'm on an interview" or "I'm taking a test" or "I have homework due tomorrow"... what's your situation 😉

Why does anyone think that SQL Server Express can handle the Enterprise quality/size of 2k5 databases? You've probably violated at least one size limit and Lord knows what else...

There must be a couple million posts on how to do something like this... and, most of them are a bad use of SQL 'cause this is a form of...

I just got done doing a conversion for "unlimited scalability" using a (yeeeeaaacchh!) Cursor (haaaaaaaaaack! Patoooooiiiii!)... it takes 17 times longer to run even though I wrote it as a...

And, unless you're going to put the sproc in the Master database, don't use sp_ as the beginning of the sproc name.

Remove the DROP TABLE and the GO... then, it should work as a sproc.

Ack... I forgot that the Name column in SysDatabases is of the SysName datatype which is actually NVARCHAR... cuts the capabilities of the script in half without a conversion.

Also, 8000...

More like SPAM than anything else...

Dynamic cross-tab...

http://www.sqlservercentral.com/Forums/Topic242919-8-1.aspx

Yes... you need to write it in a "special" way... without a cursor! 😉