• tabinsc (6/6/2013)


    2008R1 tells me:

    Msg 102, Level 15, State 1, Line 9

    Incorrect syntax near '='.

    It doesn't appear to like the @a = @B.

    IIF isn't supported in 2008, it's new to 2012. That's why you're getting an error.