p.s. Here's hoping that you really are using SQL Server 2014. IIF came out with 2012 and it resolves to CASE operators behind the scenes but it sure does simplify code. In case you've never used it, it syntactically boils down to...
IIF(SomeConditionIsTrue, ThenThis, ElseThis)
The equivalent CASE operator would be...
CASE WHEN SomeConditionIsTrue THEN This ELSE This END
--Jeff Moden
Change is inevitable... Change for the better is not.