Rolling up multiple rows into a single row and column for SQL Server data

PHOTO EMBED

Tue Nov 29 2022 12:33:34 GMT+0000 (Coordinated Universal Time)

Saved by @paulbarry

SELECT 
   SS.SEC_NAME, 
   (SELECT '; ' + US.USR_NAME 
    FROM USRS US
    WHERE US.SEC_ID = SS.SEC_ID
    FOR XML PATH('')) [SECTORS/USERS]
FROM SALES_SECTORS SS
GROUP BY SS.SEC_ID, SS.SEC_NAME
ORDER BY 1
content_copyCOPY

https://www.mssqltips.com/sqlservertip/2914/rolling-up-multiple-rows-into-a-single-row-and-column-for-sql-server-data/