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 vote251 views1 answer
Sql beginning of previous month
SQL
0 vote246 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
0 vote257 views1 answer
Sql add calculated column
SQL
1 vote244 views2 answers
How to check username in mysql command line
SQL
0 vote246 views1 answer
A network or instance-specific error sql server
SQL
2 votes267 views2 answers
Spring where to put the data sql
SQL
0 vote244 views1 answer
Time mysql w3
SQL
0 vote223 views1 answer
Store query result in variable sql
SQL
5 votes271 views2 answers
Create table mysql example auto_increment
SQL
0 vote260 views1 answer
Postgres statistics
SQL