I know this is possible, but I can't seem to get the syntax correct. Any help would be much appreciated.
Where bi.EDIID = 5444 AND (
(bid.ssn IS NULL and el.PersonId is NOT NULL)
(el.personid is NULL and bid.ssn is NOT NULL)
CASE WHEN (bid.SSN IS NOT NULL AND el.personid IS NOT NULL)
THEN ((el.PremiumDue <> bid.PremiumDue)
or (el.PremiumDueRound <> bid.PremiumDueRounded))
ELSE (1 = 2)