Combine Rows into String in SQL Server

makenzi....

Hi,

How to combine rows into string in SQL Server?

I have data like

Name

Mudassar

John

Robert

Output should be

Mudassar, John, Robert

Joey

0 1

Use COALESCE function.

Database

For this example I have used of Northwind database that you can download using the link given below.

Refer below query.

SQL

DECLARE @Names VARCHAR(MAX)
SELECT @Names = COALESCE(@Names + ', ', '') + [FirstName] 
FROM Employees

SELECT @Names

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Description

Description is required.