Rolling up Multiple Rows into a Single Row (STUFF)
SELECT
SS.SEC_NAME,STUFF((SELECT'; '+ US.USR_NAME
FROM USRS US
WHERE US.SEC_ID = SS.SEC_ID
ORDERBY USR_NAME
FOR XML PATH('')),1,1,'')[SECTORS/USERS]FROM SALES_SECTORS SS
GROUPBY SS.SEC_ID, SS.SEC_NAME
ORDERBY1
No comments:
Post a Comment