I also agree that things like email shouldn't be sent in a trigger and I agree that the CC can take some of the burden when sending the same email to multiple people, but it would be awfully nice if you could send a result set to the intrinsic email que...

Short and Solid. Nice post, Nakul....

I didn't down-vote the two posts above but understand why they were down-voted... The first one doesn't actually address performance (which is what Madhivanan's question is all about), at all. The second answer doesn't explain why "cursors are a b...

@Jahid, p.s. Don't expect to be able to print out the variable and see more than 8,000 characters because SSMS doesn't like to do such a thing. Rather, use LEN() to confirm that the variable holds more than 8,000 characters....

@Jahid, Look again. The variable used by Madhivanan is a VARCHAR(MAX) which will hold up to a binary 2 billion characters, which is a tidu sum more than a mere 8,000. If you are stuck in SQL Server 2000 or less, then it is very likely that you wi...

> Thanks Jeff Moden for your valuable > feedback. Whenever there is a post > about tally number table, I always > refer your article. I'm truly humbled, ol' friend. Thank you....

Nicely done and thank you for the honorable mention. I've also seen single column Holiday and other reference tables, some of which are also used for "Pull Down" menus in applications....

Since closing the conection in Step 7 effectively ends the session, you don't have to drop the Temp Table. It will drop all by itself. As a matter of fact, if the script is used a whole lot, there's a benefit to NOT explicitly dropping the Temp Table....

Nicely done, Nakul. I still use this method instead of Table Valued Parameters. It just seems easier....

...