Sql roll up rows into columns

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

Similar codes

1 vote145 views1 answer
Python escape string for sql
SQL
0 vote217 views1 answer
Microsoft word insert sql code
SQL
0 vote289 views1 answer
Sqlalchemy _in array sqlite
SQL
0 vote216 views2 answers
Jsonb
SQL
-1 vote189 views3 answers
Error mysql shutdown unexpectedly
SQL
2 votes191 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
1 vote204 views1 answer
Mysql get max value and id
SQL
0 vote247 views1 answer
Select count concat string sql server
SQL
22 votes319 views4 answers
Mysql date format
SQL
0 vote204 views1 answer
How to create a new db from dumb file mysql
SQL