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

0 vote234 views1 answer
Sql create text column limited values
SQL
0 vote256 views1 answer
Openquery join two tables
SQL
0 vote226 views1 answer
Object Information
SQL
3 votes224 views2 answers
Oracle sql truncate table
SQL
0 vote227 views2 answers
How to save result of sqlite query in a table
SQL
1 vote250 views1 answer
Table infromation in sql server
SQL
0 vote227 views1 answer
Mysql max number not returning correct value
SQL
2 votes227 views1 answer
Select from array in psql
SQL
0 vote228 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
0 vote266 views1 answer
Mysql case when on date
SQL