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
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
No comments:
Post a Comment