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 vote256 views1 answer
Alter database name script
SQL
1 vote173 views1 answer
Floor function in sql oracle
SQL
1 vote266 views1 answer
Oracle create program if not exists
SQL
0 vote232 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote233 views1 answer
Sql tablo sp
SQL
3 votes275 views2 answers
Savepoint in sql
SQL
13 votes196 views2 answers
Sql join
SQL
1 vote186 views2 answers
Pad zero sql server
SQL
0 vote196 views1 answer
Postgres list all triggers
SQL
0 vote177 views1 answer
Sql server manager close connection
SQL