After reading your newsletter today and finding out about the Table data type, I am attempting to convert one of my most used stored procedures to use the table data type instead of temp tables. One of the things the stored procedure does is dynamically generate an insert statement to insert data in the the current temp table. This works fine. However, I cannot seem to find a way to perform this same task using a temp table, since when I call the EXEC on the dynamically generated SQL it has no idea of the table variable I am referencing in the INSERT statement. Any help would be appreciated. How could I get around this? I do not want to have to program a complete different CASE for each unique set of variables that can be passed into the stored procedure. This would make for a very long and ugly stored procedure. Thanks for the help in advance. And congrats on the new forum! I hope to be on here quite often.