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 2005 Forums
 SSIS and Import/Export (2005)
 Inserting into a table from a RecordSet

Author  Topic 

jrp
Starting Member

4 Posts

Posted - 2009-07-01 : 08:06:32
Is it possible to insert into a table from a RecordSet without using a ForEach loop? In saying that how much overhead is a ForEach (generally speaking)?

rajdaksha
Aged Yak Warrior

595 Posts

Posted - 2009-07-02 : 04:12:26
Am not sure. what you expect ....:)

select
col1,col2,col3,col4,col5
INTO #tempTable
from <Table_Name>

select * from #temptable
Go to Top of Page
   

- Advertisement -