How to select comma separated list in Sqlserver

Question

Anonymous User · Answer

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.

forum

How to select comma separated list in Sqlserver

Can you answer this question?

1 Answers