Handy function to remember:
1 2 3 4 5 6 7 8 |
SELECT * FROM orders AS o CROSS APPLY ( SELECT linenotes + ',' FROM orderLines AS ol WHERE ol.orderID = o.orderID FOR XML PATH('') ) temp ( listOfLineNotes ) |
Handy function to remember:
1 2 3 4 5 6 7 8 |
SELECT * FROM orders AS o CROSS APPLY ( SELECT linenotes + ',' FROM orderLines AS ol WHERE ol.orderID = o.orderID FOR XML PATH('') ) temp ( listOfLineNotes ) |