⬅ Back Check Same Code Master In Embroidery.sql
use E23D001

SELECT COUNT(ACCCODE), ACCNAME FROM (SELECT AccName, acccode FROM commone.DBO.ACCOUNT_MASTER UNION SELECT AccName, acccode FROM E23D001.DBO.ACCOUNT_MASTER ) AS T1 GROUP BY ACCNAME HAVING COUNT(ACCCODE)>1