Array processing - before SQL Server 2000, you can only create temporary table, but now you can create an arrary.

DECLARE arraryname TABLE (....)

It is just liked creating a temp table but it does not take up space in Tempdb.

You use the exact same command to insert data and select data but you don't have to delete it afterward.