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 vote353 views4 answers
Sql now
SQL
0 vote352 views1 answer
Sqlcmd xml output insert line break after every 2033 characters
SQL
0 vote374 views1 answer
How to move a columns location in mysql
SQL
0 vote339 views1 answer
Import sql dump into postgresql database
SQL
0 vote380 views1 answer
Sql injection payload list github
SQL
0 vote344 views1 answer
Sql waitfor
SQL
0 vote378 views1 answer
Neo4j command to run script file
SQL
0 vote360 views1 answer
Import sql inside hide sql
SQL
1 vote354 views1 answer
Mysql check string don't have number
SQL
20 votes363 views1 answer
Sql change column types
SQL