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

we are a community of more than 2 million smartest coders
registration for
employee referral programs
are now open
get referred to google, amazon, flipkart and more
register now
  
pinned-register now
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