I am trying to run a query to one of two delete duplicates records. The process I normally use is use
1) SELECT DISTINCT from the table into a second table
2) Delete all duplicate values in original table
3) Copy the disctinct values from the second table back into the original table

Unfortunately, this time, my table has ntext fields in it. SELECT DISTINCT does not work with ntext fields.

Does anyone have an alternative solution?

Thank you,
JLFleming

Add another column of type int and enable its IDENTITY attribute, to the same table and by this you would get unique values, and that should be easier to delete the duplicate rows.

_________________________
- Vijay G
Strive for Perfection

Fleming, are you really trying to delete duplicate rows or are you looking to identify each row distinctly? If you are need to add uniqueness to each row (identify each row distinctly), then Vijay's response will work. If not and you are truly trying to delete duplicate rows, I think there is an easier way to do this. As you found out, you can't SELECT DISTINCT on a ntext field. Is there another field you could SELECT DISTINCT on? Depending on your answer, it might be possible to do this in a single statement without the hassle of your 3 steps above.