Selecting into Temp Tables

[SeaninSeattle]

My brain is totally shot - anyone remember what the syntax is for pulling a ton of data into a temp table? It was something like

Select into #temptablename ...Fieldnames
from ...tablename
where ...constraints

Thanks,
//sse

Sean Engle
Admin/DirIS
ssengle@bswusa.com

 

[Pattycake245]

Quicker if you create the temp table first then populate it with:

create table #temptable (fields)

insert into temptable(fields)
select fieldtrs from physical table

Tim

 

[MartinCroft]

This will also do the trick without need to create the
table, thats if this is what you want. wont work on an existing table then pattycake repsonce will be best

--selecting fields
select OrderId,CustomerID,OrderDate into #temp from Northwind..orders

or

-- All rows
select * into #temp from Northwind..orders