Merge rows with comma separated values in SQL Server

nauna

SOLVED CLOSED ACTIVE ANSWERED
User: nauna
Posted: on Nov 25, 2019 05:45 AM
Forum: SQL Server
Answer: 1
Views: 3833

i have this query which return 3 rows as xml

Value 1

value 2

value 3

i want instead of rows it should return comma sepearted values like

value 1, value 2, value 3

SELECT distinct p.ProductName
FROM dbo.Meals AS meals
INNER JOIN dbo.MealRecipes AS mr ON mr.MealID = meals.MealID
INNER JOIN dbo.Recipes AS rec ON rec.RecipeID = mr.RecipeID
INNER JOIN dbo.Products AS p ON p.ProductID = rec.ProductID
ORDER BY p.ProductName
FOR XML PATH ('Item'), TYPE

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
ANSWER
User: dharmendr
Replied: on Nov 25, 2019 05:48 AM
Modified: on Nov 26, 2019 05:40 AM
Report

Hi nauna,

Refer below query.

SQL

SELECT STUFF(
    (SELECT ',' + CAST(CustomerId AS NVARCHAR)
    FROM Customers
    FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)'), 1, 1, ''
)
FOR XML PATH('Item'), TYPE

Output

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

Merge rows with comma separated values in SQL Server

Company

Explore

Follow us

Contact Us