Why not just do this?

Insert into EmployeeCopy

select * from Employee

UNION

select * from Employee

voila -- duplicates gone! However, they have to be duplicates in every field for this to work, but I suppose they're not really true duplicates if they don't match in every field.