Well, I am confused.

Whatever happened to the concept that you cannot assign a result set to a scalar -- Should this not be barfed out at compile time in the first place ? I certainly would prefer

it be so, in case I make an error while coding something like this, rather than have this bizarre and not necessarily predictable behavior.

If I remember previous versions, it used to be that way.

But even when doing this for a string instead of an integer, it still results in a long string which concatenates all of the values.

Regards