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 vote217 views2 answers
Backup table mssql
SQL
0 vote202 views1 answer
Mysql query with sql to get the next row
SQL
0 vote194 views1 answer
How to check replication lag in mySQL
SQL
0 vote218 views1 answer
Sql datediff db2
SQL
0 vote182 views1 answer
Clone table structure mysql
SQL
1 vote238 views1 answer
Insert many to many sql
SQL
4 votes243 views1 answer
Ms sql truncate table vs delete
SQL
0 vote230 views1 answer
Mysql grant all on all databases
SQL
0 vote211 views1 answer
Dbms_output sql developer
SQL
17 votes208 views6 answers
Mysql import sql file
SQL