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 vote280 views1 answer
DoVerify() must be an instance of Lcobucci\\JWT\\Signer\\Key
SQL
22 votes290 views4 answers
Mysql date_format
SQL
0 vote276 views1 answer
Select all tables linked server sql
SQL
0 vote282 views1 answer
Mysql count unique in group statement
SQL
0 vote263 views1 answer
Replace sqlalchemy
SQL
0 vote305 views1 answer
Soql queries for not contact related account records in salesforce
SQL
0 vote332 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
1 vote288 views1 answer
Where to locate set password for mysql
SQL
14 votes291 views3 answers
Alter foreign key
SQL
0 vote305 views1 answer
Get primary key of table
SQL