I receive the data into one of my tables from a text file which has some duplicate records. How do I delete them. For example:<BR> Field1 Field2<BR>1 AB DE<BR>2 AB DE<BR>3 AB 12<BR><BR>So here 1 and 2 are duplicates but 3 is not since the Field2 is not the same. So basically all the fields value has to be same not just one field. <BR>I was thinking of writing some kind of SP to search those duplicates or a trigger, how to do that?