You could insert all records into another table with an IDENTITY or other
key column, delete the suspect rows using the described methods, then move
all the records back.
Quote:> Looking for any ideas on how to delete duplicate records
> from a table where there are NO unique values in ANY
> column whatsoever. Apparently it was someones idea of a
> joke NOT to use a primary key!!