Temporary Tables are a handy technique for creating cascading logic. Results from one temporary table can be passed to other temp tables. This can simplify the process for creating complex result sets.

Temporary tables are saved to disk, and are visible in the tempdb database in the system database folder. As they are saved to disk, they can be used to manipulate larger datasets than say table variables that save the result set to memory/RAM.

Temp Tables fall into two categories- local & global temp tables. Local are accessible only to current session while global are accessible to other sessions.

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...