在SQL Server中有自动创建临时表的方法吗

I have a rather complex SELECT statement in a stored procedure that I am updating to insert the rows from the select into a temp table. To define the temp table, I need to know the data type of each every item selected. statement in a s