Home Forums SQL Server 2008 T-SQL (SS2K8) Avoiding insertion of duplicate rows RE: Avoiding insertion of duplicate rows
Ninja's_RGR'us
SSC Guru
Points: 294069
More actions
August 9, 2011 at 12:03 pm
#1366131
Insert into base...
SELECT FROM qry .... WHERE NOT EXISTS (SELECT * FROM base where qry.id = base.id)