Home Forums SQL Server 2008 T-SQL (SS2K8) Avoiding insertion of duplicate rows RE: Avoiding insertion of duplicate rows
Flexdog
SSC Veteran
Points: 280
More actions
August 10, 2011 at 9:55 pm
#1367044
insert tableb(lname,fname,phoneno)
select a.lname,a.fname,a.phoneno
from tablea a
left join tableb b on a.lname=b.lname and a.fname=b.fname and a.phoneno=b.phoneno
where b.id is null
A longer version of Ninja's suggestion...