Need to get rid of duplicate contact2 entries in the database

Version 1

    Details

    Need to get rid of duplicate contact2 entries in the database


    Resolution

    Here is a SQL query to identify the duplicate contact2 entries in the database but you will have to identify the ones you want to delete and then delete them from SQL:  select company, contact, contact2.recid, contact2.* from contact1, contact2 where contact2.accountno in(select AccountNo from contact2 group by accountno having count(*) > 1) and contact1.accountno = contact2.accountno order by contact1.accountno  Note: This sql query only identifies the duplicate entries, you will still need to look at each entry to determine which of the duplicate records need to be kept and which ones to delete.   FrontRange Solutions does not provide assistance with actually deleting the records, and recommends for our customers to work with a Certified Solutions Partner for such issues.