Temporary Tables

Here is a good article on the various sorts of temporary tables in SQL Server.  In my day-to-day work, I tend to use the @table variables rather than #temp tables, and certainly never the ##global temp tables.