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! 😉

That would be part of the inconsistency... procs recompile when certain amounts of data...

I can't prove it, but apparently you have... I've heard that the sp_OA* procs have a "connection leak"...

Real key here is what do you think you need an sp_AO* string...

I don't see any similarity, either, except for the fact that Alicia has, again, not shown anything that she's tried (not to mention the double post).