I have a table that it continuos grow drastically due to an error on an automatic import. I cant control that but I can clean the table removing the duplicates. What would be the best approach?
here is the query that returns the records:
SELECT DISTINCT [RecordID]
I know the RecordId is unique so if I remove that on the select I will give me the records I need but I need to remove them for good.
The Printime is a date time field. but there is not way that records will have the same time, DocumentName ...
I hope this is enough information