Home Forums SQL Server 2008 SQL Server Newbies it takes too long to insert data to different tables RE: it takes too long to insert data to different tables
bdloving 4446
SSC Enthusiast
Points: 198
More actions
February 21, 2013 at 1:05 pm
#1590110
Why do 1 insert call per temp table row on a 10,000 row temp table?
just
INSERT
INTO [dbo].[Computers]([NetBIOSName], 127.0.0.1)
select netbiosname,ip from temptable
where temptable.netbiosname not in ( select netbiosname from computers))