Temp tables persist until then connection closes, so you don't have to do it all in one query.<BR><BR>Alternately, try collapsing your queries and eliminate the whole idea of a temp table.

Then they're there, no one knows it, and you can use the full functionality of Access.<BR><BR>When you're done, you might do a benchmark between using the temp table versus sql server to see if it ...

Learn More. In this, Part 4 of a series on programming T-SQL, Gregory Larsen details how to set variables in calling T-SQL code while using sp_executesql.