(SELECT ',' + Cast(Order_ID.OrderID as varchar(30))
FROM test AS Order_ID
WHERE Order_ID.OrderNo = test.OrderNo
FOR XML PATH('')), 1, 1, '') AS OrderID
Open in new window
Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.