Insert into temporary table from Stored Procedure

Example of SQL Server 2008's ability to insert data into temporary tables or table variables from an EXEC statement . This includes populating the temporary objects from a stored procedure.