How to find Case Mismatches from HEATCAI CustTypes to Profile CustTypes in HEAT Help Desk

Version 1

    Details

    Case mismatches between the CustType values on HEATCAI and CustType values on Profile can cause issues with HSS.


    Resolution

    Run the following in SQL Server Management Studio to identify records where the case is different between the HEATCAI.CustType and the Profile.CustType:

    SELECT DISTINCT(CustType), CustID

    FROM HEATCAI

    WHERE (CustType  IN

    (SELECT CustType FROM Profile)

    AND CustType Collate SQL_Latin1_General_CP1_CS_AS NOT IN

    (SELECT CustType FROM Profile))