Friday, July 20, 2012

Insert into without duplicates



INSERT INTO  TableDuplicates
(empId)
SELECT  empId
FROM TableEmployees
WHERE empId NOT IN (select empId from TableDuplicates)

No comments:

Post a Comment