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

OH! SPID!  I thought you meant "spud" and built a spud cannon over the weekend   Hmmm... maybe THAT will work on the users...

Joe... I don't use formulas for the Holidays nor did I suggest that... that would be stupid.  Go back and look at what I said... I agree that a Holiday...

Manish,

I appreciate your attempt at simplification of the problem ... but you at least need to say that your real code has 10-12...

Now, THAT sounds like a cross-join... post the code and let's have a look-see... (provided it's not hundreds of lines long ).