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 vote376 views1 answer
Xamarin sql lite create table if not exist
SQL
24 votes401 views6 answers
Replace mysql
SQL
0 vote354 views1 answer
Configure: error: Cannot find libpq-fe.h. Please specify correct PostgreSQL installation path
SQL
0 vote358 views1 answer
Set open file limit mac catalina mysql
SQL
0 vote366 views1 answer
How to read the potentail error messages in ssis package
SQL
6 votes352 views1 answer
Update left join mysql
SQL
0 vote378 views1 answer
Make parameters nullable in sql server
SQL
12 votes349 views1 answer
Create column sql server
SQL
0 vote331 views1 answer
Clone table structure mysql
SQL
1 vote387 views1 answer
Wherein mysql
SQL