Inconsistent formatting in 126.96.36.1994
Case When ( c.TerminationDate < '01/01/2008' And n.EntityTypeID = 10 ) Then 'Candidate Committee' Else et.EntityTypeName End As 'CommitteeTypeName', Iif(c.TerminationDate < '01/01/2008' And n.EntityTypeID = 10, 'Candidate Committee', et.EntityTypeName) As 'CommitteeTypeName',
It's a bit hard to get things to line up in the forum, but basically in the Case, the "And n.EntityTypeID..." lines up under the "c.TerminationDate...), which is what I expected to see in the Iif. But instead, the "And ..." is forced to a new line and left justified.
Ultimately, I would like more control and not have these "short expressions" split over two lines. Probably based upon line length. I will get around to posting this to the SurveyMonkey also.