Hmmm... let's see...

Oracle protects me by doing an auto-commit if I happen to mix some DDL in a proc.  Really helpful there.  With SQL Server explicit transactions, I have to...

Who are you?  Why, you're part of a TEAM... and the TEAM failed.  You're not just another developer if you were part of the interviewing TEAM.  You should have asked...

Oh well, I tried... looks like yet another newbie got what they wanted but not what they needed... knowledge

Peso, ol' friend... if you...

P.S.  Increasing the number of rows to 30,000 (just added 50% more rows), caused the time on the first running total example to more than double at 4 minutes and...

Karthik,

I don't mean to sound so cynical about all the "experts"... wait, no... I do   But no one teaches the "basics" anymore.  I...

Oh, I dunno... I've seen those blogs and many more... they go on about how to configure hardware, how to split TempDB, how to defrag indexes, how to use (too...

Nah...too simple and way too fast... interferes with Scotch drinking time... create a double nested cursor to slow it down 

Yes, you can... best way to learn this one is to look up CREATE PROCEDURE in Books Online and read about it

You bet, Mick.  Thanks for the feedback...

This is an SQL Server 2000 forum... and there's no UNPIVOT in SQL Server 2000

BCP from Command Prompt itself (batch file) or Proxy user to run a job that has privs.  Guess you could also use DTS if you really had to...

Hello, Tim?   You still there?

Heh... why?  If you think this is bad, do a search on "Bankers Rounding"

OR... NOT...

Best if you keep the content of table variables pretty short... they do not use nor can they be made to use Statistics... there are other disadvantages to table variables,...