In SQL Server I have a table like below:

table

Now I want to return Name Column value as comma separated using SQL Server statement:

code

  1. SELECTSTUFF((SELECTDISTINCT', '+CAST(Name ASVARCHAR(100))
  2. FROM Emp_Information FORXMLPATH('')),1,2,'')AS Employees