Group Concat MS SQL
SELECT TOP 1000
T.orderItemId
, STUFF(( SELECT ','+(attribute_name+': '+attribute_value) FROm qsorderoptions where qsorderoptions.orderItemId =T.orderItemId
FOR XML PATH('')) , 1 , 1 , '' ) AS Feld
FROM
qsorderoptions As T
--GROUP BY T.product_id
GROUP BY
T.orderItemId
Dein Kommentar
An Diskussion beteiligen?Hinterlasse uns Deinen Kommentar!