TheSQLGuru (10/2/2012)
I will add that I DEFAULT to using temporary tables and only switch to table variables in VERY exceptional situations.
I do the same; I've almost never seen any situation where table variables had a measurable performance improvement. The reverse, however, is not true.