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 which is null. That's the one that is returning a null value.