Per concatenare record in MSSQL รจ necessario usare la sintassi:Tabella PeoplePeter,Paul,Mary,
DECLARE @Names VARCHAR(8000)SELECT @Names = COALESCE(@Names + ', ', '') + Name FROM People
Ottenendo il risultato Peter,Paul,Mary