How to select comma separated list in Sqlserver

Total Post:341

Points:2389
 1261  View(s)
Ratings:
Rate this:
I want  to select comma separated list in Sql Server please help me.
  1. Post:281

    Points:2003
    Re: How to View comma separated list from column using select statement In Sqlserver

    When we want  to generate a comma separated list of columns values like a list of EmailIDs to send mail. In SQL Server, we can make a comma separated list by using COALESCE as shown in below.
    Use of COALESCE to create comma separated list
    Suppose we have following data in Employee table and we need to make a semicolon separated list of EmailIDs to send mail, then we can use COALESCE as shown in below.

    declare @strEmailid Varchar(max);

    select @strEmailid=COALESCE(@strEmailid+',','')+ EmailID FROM Employee

    PRINT @strEmailid

      Modified On Apr-10-2018 06:49:36 AM

Answer