SQL Server temp tables are an essential component of the SQL Server database management system that allow users to temporary store and process data within a session or a query. They are temporary in ...

SQL Server procedures can have, at most, 2100 parameters. Server-side logic is required to assemble these individual values into a table variable or a temporary table for processing.

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