mssql

MSSQL: Cross Apply with XML

August 28, 2011 by Tom Leave a Comment

Handy function to remember:

SELECT *
FROM orders AS o
CROSS APPLY (
	SELECT linenotes + ','
	FROM orderLines AS ol
	WHERE ol.orderID = o.orderID
	FOR XML PATH('') )
temp ( listOfLineNotes )

SELECT *

FROM orders AS o

CROSS APPLY (

SELECT linenotes + ','

FROM orderLines AS ol

WHERE ol.orderID = o.orderID

FOR XML PATH('') )

temp ( listOfLineNotes )

http://www.stillnetstudios.com/concatenating-child-rows/