Came across some code that someone else has written and don't have a good way to test it at the moment.
Just looking at this bit of it, what do you guys think the below code return if the LoanT = 1 AND the ReportingT = 9? Federal or Gin?
CASEWHEN L.LoanT= '1' THEN 'Federal'
WHEN L.LoanT = '2' THEN 'Veterans'
WHEN L.LoanT > '2' THEN 'Other'
WHEN Inv.ReportingT IN (1,9) THEN 'Gin'
WHEN Inv.ReportingT = 0 OR Inv.InvID = 'REO/F' THEN'Fred'
WHEN Inv.ReportingTy IN (6,7,8) AND Inv.InvID <>'REO/N' THEN 'Privates'
ELSE 'Fan' END AS InvTyp,