Control provides an option as to whether duplicate companies are allowed. Even with this option set to not allow duplicates, they may be created from import or have been there from the past. This query will help identify the duplicate company names in the system.

If a customer receives a “company already exists” message when trying to add a company record in the system, you can usually identify the pre-existing company using Company Explorer. Make sure all options are selected (prospect, client, vendor, personal, etc.) and that inactive companies are also being searched.

For a complete listing of duplicate company names, you can use the following query.

None. This is a selection query and no data is modified in the running of it.

SELECT CompanyName, COUNT(CompanyName) AS TheCount
FROM Account
GROUP BY CompanyName
HAVING COUNT(CompanyName) > 1
ORDER BY TheCount DESC, CompanyName

• Entered : 8/15/2009
• Version : Control 2.5+