sql server - Using COALESCE function to make values separated with commas

Question

I have a table (EMP) I know that using the COALESCE function we can get the values of any column in this way

23,23,45,34

SELECT OfferID  FROM Emp where EmpID= 23

but I am not getting the syntax to achieve this

Any help would be great, to resolve this issue.

Answer 1

Description

I have done this using COALESCE in the past too, but i suggest another approach because you dont need a variable. Use the T-SQL function STUFF to get this done.

Sample

SELECT STUFF((
    select ','+ cast(OfferID as nvarchar(255)) 
    from Emp b
    WHERE a.EmpID= b.EmpID
    FOR XML PATH('')
    ),1,1,'') AS COLUMN2
FROM Emp a
GROUP BY a.EmpID

More Information

STUFF (Transact-SQL)