Free for PREMIUM members
Go Premium for a chance to win a PS4. Enter to Win
CREATE FUNCTION dbo.ConcatSO(@Shipment int)
DECLARE @res VARCHAR(MAX)
SELECT @res = COALESCE(@res + ' ', '') + CAST(SO AS VARCHAR(100))
WHERE shipment = @shipment
and your query will be like this:
SELECT t.shipment, dbo.ConcatSO(t.Shipment) SO_list
FROM yourtable t
GROUP BY t.shipment
Open in new window
Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.