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 vote221 views1 answer
Postgresql comandos basicos
SQL
7 votes171 views1 answer
Alter table add key sql
SQL
0 vote207 views1 answer
Arithmetic expression in sql
SQL
0 vote225 views1 answer
Add multiple field in table sql
SQL
5 votes213 views2 answers
Mysql date greater than 30 days
SQL
0 vote236 views1 answer
Suhaib
SQL
0 vote221 views1 answer
PGSQL dynamic table name
SQL
0 vote216 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
1 vote212 views1 answer
Add constraint sql
SQL
1 vote208 views2 answers
Mysql does sentance contain word
SQL