I have found both temporary tables and variable tables to be useful. I have found this article to have a good explanation of when to use each.

http://databases.aspfaq.com/database/should-i-use-a-temp-table-or-a-table-variable.html