sql temp table

[jashimu]

Hi all, How to create temp table with new column name from a existing table that has different column name. thanks

modified on Wednesday, February 3, 2010 8:19 AM

[Ashfield]

Easy

select column1 as newname
into #temp
from oldtable
where 1 = 2

insert into #temp(newname)
select column1
from oldtable

By creating an empty table you avoid locking a lot of the system tables in tempdb - ALL the time a select into is running the system tables in tempdb are locked, which prevents other users from creating temp tables.

Bob Ashfield Consultants Ltd

[jashimu]

I will have to try it then I will let you know. thanks for your help

[leckey 0]

Jashimu--you have been a member long enough to know not to use such a general message title. Please refresh yourself with the forum guidelines if needed!

Back in the blog beatch! http://CraptasticNation.blogspot.com/[^]