xxxxxxxxxx
-- SQL server COMMA-SEPARATED LIST OUTPUT
DECLARE @VALUES_comma VARCHAR(MAX);
SELECT @VALUES_comma = COALESCE(@VALUES_comma + ', ' + CONVERT(varchar, #FIELD# ), CONVERT(varchar, #FIELD# ))
FROM #TABLE#
-- using GROUP
SELECT top 10
profile_id,
STRING_AGG(id,', ') WITHIN GROUP (ORDER BY id ASC) id_list
FROM data_participations (nolock)
GROUP BY profile_id;