hi David,

in the article the varaibale is initialized with '' - an empty string. This is not necessary. When declaring a variable with out extra value assignment, it gets initialized...

hi Hugo,

I'd like to disagree. While the last example uses only @var = column the explanation above it clearly states:

"If a SELECT statement returns more than one row and the...

hi Hugo,

http://msdn.microsoft.com/en-us/library/ms187953.aspx

states that the result is defined as the value of the last row and not undefined as Umachandar in the Connect ticket says, should be corrected then.

USE...

hi Hugo,

What do you mean with "incomplete data"?

I only found these articles:

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/18/449.aspx

http://sqlblog.com/blogs/adam_machanic/archive/2006/07/12/t-sql-variables-multiple-value-assignment.aspx

http://ryanfarley.com/blog/archive/2004/03/01/390.aspx

They only explain the obvious: When assigning a single value using the SELECT...

hi,

I would either use one of both solutions:

DECLARE @Concat NVARCHAR(MAX) = '' ;

SELECT @Concat = @Concat + ', ' + StatusDesc

FROM MyStatus ;

SELECT STUFF(@Concat, 1,...