SQL Server throws a wobbly when one tries to declare/create the same-named temporary table more than once in the same procedure - I guess the query analyser assumes that all temp table creations ...

Practical .NET Speed Up Your Application with Stored Procedure and Temporary Tables Stored procedures can speed up your code by reducing trips to your database -- even if you only have one SQL ...

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 ...