How to list contents of HEATCAI where the CustID is duplicated.
This can be handy if needing to know what CustID is allowing more than one LoginID in HEAT Self Service.
Run the following SQL statement in SQL Management Studio and it will return a list of rows for all CustID's that are being used more than once.
FROM HEATCAI a INNER JOIN
GROUP BY CustID
HAVING COUNT(*) > 1) b ON b.CustID = a.CustID