• I'd be intereseted to see some actual performance results.  In my mind, it doesn't make sense that a table variable used in this fasion is faster then a cursor.  A table variable adds the over head of having to create the table with an additional column and then select into it before you can even get started.

    I do see the value of a table variable in being able to pass it to a store procedure, and the more limited scope and clean up, but I still use temp tables (mainly because it is easier to use the "insert into #mytemp   exec my_sp")