• 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))