Table variables are fast but they can only be used in the context in which they were Declared. They can't be used with:
Select .. Into @TblVar
Insert @TblVar Execute ...
Passed to/from...
PeteK
I have CDO. It's like OCD but all the letters are in alphabetical order... as they should be.