After a long wait and many, many requests, the IIF function is finally coming to SQL Server 2012! If you aren’t familar with this function but yet you do use CASE statements, you’re going to love the IIF function. Check out the MSDN entry and see!
Happy Coding!!