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 vote137 views2 answers
Sqlalchemy core in clause
SQL
5 votes163 views2 answers
Postgresql insert select
SQL
0 vote152 views1 answer
How to see the query of a view in mysql
SQL
0 vote141 views1 answer
Check if table exists oracle
SQL
0 vote184 views1 answer
Add computed column to table sql server
SQL
0 vote156 views1 answer
Can sqldatareader be null
SQL
0 vote150 views1 answer
Mysql update from n to 100
SQL
0 vote150 views1 answer
Declarative base sqlalchemy
SQL
0 vote140 views1 answer
Sql contains numeric characters
SQL
0 vote144 views1 answer
Mysql read row
SQL