Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Temporary table

Author  Topic 

ricky007
Starting Member

4 Posts

Posted - 2007-08-28 : 12:55:10
How to create temporary table using query.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-08-28 : 12:57:38
1 Select columns into #temp from (query) as T
2
Create table #temp(col,.........)
Insert into #temp(columns)
Query

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -