You could try this neat bit of code. Again you would have to define in your select statement what constitutes a duplicate;-

WITH tblTemp as

(

SELECT ROW_NUMBER() Over(PARTITION BY C.contactname ORDER BY...

I just spent a whole weekend on this problem. My CSV file contains text data contained within double quotes, eg "blah",1,1/10/2011,"blah" and numeric and date data. All fields are delimited...