select OwnerID, FSL_TableCode ownerType, 'ADMIN' anomalyType, 'loginCredentialAnomalyDetector' detectorName, 'Login Enabled but Email or Password blank for user (Name: ' + FirstName + ' ' + LastName + ', ID: ' + CAST(fspro_userid AS VARCHAR(7)) + ')' message, 1 anomalyCount, COALESCE(Email,'') Email, COALESCE(FSPro_Password,'') Password, fspro_userid from tbl_FSPro_Members where LoginEnabled = 1 and ( Nullif(Email,'') is null or Nullif(FSPro_password,'') is null )