create table as select - SQL Server Central. Microsoft SQL Server tutorials, training &

maybe you could try like this in your SP or query: create table #temp(@field1 int,@field2 varchar(10)) insert into #temp select a,b from tableFrom ... n T-SQL You can do it with the following syntax select * into [new_table_name]from [table_name] example

www.sqlservercentral.com