Should I use a #temp table or a @table variable?

A temporary table is created and populated on disk, in the system database tempdb ... you can (unlike #temp tables) choose to create a table in another database, ... Table variables are only allowed in SQL Server 2000+, with compatibility ..

databases.aspfaq.com