2
3
4
5
6
7
8
9
10
11
|
USE AdventureWorks2012
GO
SELECT CAT.Name AS [Category],
SubCatName =
STUFF(( SELECT ','+ SUB.Name AS [text()]
FROM Production.ProductSubcategory SUB
WHERE
SUB.ProductCategoryID = CAT.ProductCategoryID
FOR XML PATH('')
), 1, 1,'')
FROM Production.ProductCategory CAT
|
SELECT p.ParentId
, p.FirstName
, p.LastName
, p.Age
, STUFF(
(SELECT ', ' + c.FullName
FROM @Children c
WHERE c.ParentId=p.ParentId
FOR XML PATH('')
), 1, 2, '') AS Children
FROM @Parents p
