Hello Developers,

In this demonstration, you will find how to make comma-separated columns from a data range. This problem occurs when you demonstrate wide range of dataset. Many of us try different approaches, but I found it easy to write and take less execution time in the compilation. Let's see.

Suppose I have a set of data like below:

Here we use FOR XML PATH in MSSQL Server. For that, we will put the data in a #table_name table. And follow the below code to get the output.

select distinct t.[UserID],
  STUFF((SELECT distinct ', ' + t1.Name
         from #table_name t1
         where t.[UserID] = t1.[UserID]
            FOR XML PATH(''), TYPE
            ).value('.', 'NVARCHAR(MAX)') 
        ,1,2,'') as rows
from #table_name t;

If we execute the code in MSSQL Server then we get the desired output like the below:

Hope you can get help in the development journey.

Read More: How to get the first date and last date of the month from GETDATE() in mssql