Genius short-hand way of concatenating rows into single string in SQL

DECLARE @ValueList NVARCHAR(MAX)

SELECT @ValueList = COALESCE( @ValueList + ', ' + ColumnAlias, ColumnAlias, @ValueList)

FROM MyTable

PRINT @ValueList

Thanks to Alex Norcliffe for this!