Friday, October 24, 2014

IIf function T-SQL vs SSRS Behavioral Difference

This blog explains on the behavioral difference of IIf function between Reporting Services and in Transact SQL.
IIf function was a new addition in SQL Server 2012 which provides a simplified way to implement conditionally logic. Though we have a similar function available in SSRS 2005 onwards there is a small difference in the functionality between IIf function in SSRS and that in T-SQL.

I've explained this difference in the below MSDN article using few scenarios

http://social.technet.microsoft.com/wiki/contents/articles/28000.behavioral-difference-of-iif-function-in-t-sql-compared-to-ssrs.aspx

Feel free to go through this and let me know your valuable feedback