(Posted this before seeing the other answer above. Yes you have put it succinctly.)

Hi,

Sorry, I was just trying to use the minimum code.

So with code:

DECLARE @SomeTable TABLE (x int)

DECLARE

The answer is right, but I'm not convinced about the reasoning.

If I replace the SET with SELECT , I get the same result.

Just from experimenting, it seems to do with...