SQLSERVER拼接字符串

SQLSERVER拼接字符串

SELECT DISTINCT
	OrderID,
	supplier = STUFF(
		(
			SELECT DISTINCT
				',' + Supplier
			FROM
				Ord_Order_Cost t
			WHERE
				OrderID = t1.OrderID
			AND ItemType = 0
			AND CostType = 2
			GROUP BY
				',' + Supplier FOR XML PATH ('')
		),
		1,
		1,
		''
	),
	SupplierIds = STUFF(
		(
			SELECT DISTINCT
				',' + CONVERT (NVARCHAR(50), SupplierID)
			FROM
				Ord_Order_Cost t
			WHERE
				OrderID = t1.OrderID
			AND ItemType = 0
			AND CostType = 2
			GROUP BY
				',' + CONVERT (NVARCHAR(50), SupplierID) FOR XML PATH ('')
		),
		1,
		1,
		''
	)
FROM
	Ord_Order_Cost t1
GROUP BY
	t1.OrderID,
	supplier,
	SupplierID