ggeier (6/6/2013)
tabinsc (6/6/2013)
2008R1 tells me:Msg 102, Level 15, State 1, Line 9
Incorrect syntax near '='.
IIF isn't supported in 2008, it's new to 2012. That's why you're getting an error.
I figured as much; I just expected to see a different error. This error looks more like IIF is not the problem but the IIF syntax is. No big deal.
Tony
------------------------------------
Are you suggesting coconuts migrate?