bhavnabakshi
SSC Eights!
Points: 848
More actions
August 8, 2003 at 11:37 am
#81648
Can someone please tell me how to save resultset in temporary table
kingram
Old Hand
Points: 380
August 8, 2003 at 11:41 am
#469229
simplest answer:
Select * into #TempTable from Table
Andy Warren
SSC Guru
Points: 119902
August 10, 2003 at 7:54 am
#469297
That is the simplest. Better (but more work) is to do an explicit Create #temp first, then do an insert/select to populate it. Avoids blocking issues in tempdb.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply