Correct... large table variables are NOT converted to temp tables...

I strongly recommend AGAINST using table variables for anything more than a dozen or so rows because they cannot be...

I strongly recommend AGAINST using table variables for anything more than a dozen or so rows because they cannot be made to use statistics... both table variables and temp tables...

Outstanding... thank you for the feedback.

Very cool, David... fast as all get out... but try this... obviously, we have to know exactly what the scale of the decimal places is to use it or we...

>>But there are cases where a cursor is necessary.

I would agree... BUT, the problem is most people don't really know where that...

It'll take me a bit to setup some test data and write an example (an I'm going to bed for the night so not happening tonight), but I'm thinking a...

John is spot on...

I'll also add that storing text columns in the database is bad for too many reasons to post here.  If you must store text that execeeds...

Lynn is absolutely correct... for those that can't find the ROUND function in Books Online here's what the 3rd operand of "1" means...

function

Spot on, Robert!

As an alternative, check out sp_WHO in Books Online and it's undocumented cousin sp_WHO2. 

Also, I haven't check how @@PROCID reacts in a trigger but it might be another simple...

Sorry... took a bit more than 10 minutes because of all the demo code I added but here's my suggestion... I used all temp tables so you could play without having...

Gimme ten minutes... I'll be right back...

One more question... Is it possible to add a single column to the table?

Ok... this takes 2 seconds longer (1,000,000 rows in 23 seconds instead of 21)... had to work around the "zero domain" on the LOG10 function to get this to work...

There would certainly appear to be a fly in the ointment  ... thanks for the catch and sorry for the mistake folks... I'll see...