Home Forums SQL Server 2008 SQL Server 2008 - General =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1) Errors, but does not give me an error code RE: =IIF(Fields!urgency_level.Value = 2 and Fields!DateDifference.Value <=2, Fields!NeedUrgentDates, 1) Errors, but does not give me an error code
sturner
SSC-Insane
Points: 22411
More actions
January 7, 2013 at 1:43 pm
#1574521
IIF() is a microsoft Access construct. That won't work with SQL Server.
Look into the CASE statement instead.
The probability of survival is inversely proportional to the angle of arrival.