• JustMarie (9/22/2014)


    Made my guess, ran the code, got back NULL. Not an empty record set - NULL.

    So, did I. Even though that's what I answered, that's not what I was expecting since the explanation made sense to me.

    Can anyone explain why I would get something back?

    Running 2008 R2.

    Never mind. I see why. There are two select statements. The second one is doing a select on the variable @test-2 which is null. That's the one that is returning a null value.