I need an advice for a specific issue.
I have a table with 65000 records. There are duplicate records in this table. These duplicate records depends on various fields. For example;
If name, surname and email info of a customer is the same;
If name, surname and mobile info of a customer is the same;
If name, surname and one of the other phone numbers is the same etc..
I need to match the records with these rules. By the way, I shouldnt delete duplicates, mark them with a number or another way and keep in the table.
Can you please share any usefull info? Should I use just TSQL and some queries? Any other specific software? Anyone has experience?