sql 3a merging multiple row data in string

Solutions on MaxInterview for sql 3a merging multiple row data in string by the best coders in the world

showing results for - "sql 3a merging multiple row data in string"
Isabel
18 Feb 2016
1DECLARE @Names VARCHAR(8000) 
2SELECT @Names = COALESCE(@Names + ', ', '') + 
3    ISNULL(Name, 'N/A')
4FROM People
5