New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
use  go 'this insert names seems to fly (see below for update names) Insert into Names ([Name], ARDue, ARContact, ARCreditlimit) Select namesar.[name], namesar.ARDue, namesar.ARContact, convert(money,namesar.ARCreditlimit) from namesar left outer join names on namesar.[name] = names.[name] where names.[name] IS NULL 'this update names is what seems to hang Update names set [name] = namesar.[name], Ardue = convert(money,namesar.ardue), arcontact = namesar.arcontact, arcreditlimit = convert(money,namesar.arcreditlimit) from names inner join namesar on names.[name] = namesar.[name] where (namesar.[name] is not null)