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 vote352 views1 answer
Insert column after column mysql
SQL
1 vote344 views1 answer
Check message id sql server
SQL
0 vote347 views1 answer
Alter owner in PostgreSQL
SQL
0 vote387 views1 answer
Mysql last friday of current month
SQL
5 votes385 views1 answer
Mysql add user with all privileges
SQL
0 vote339 views2 answers
Mysql password error create datbase
SQL
1 vote390 views2 answers
Grab part of a string sql
SQL
1 vote338 views1 answer
Mysql pretty date format
SQL
0 vote382 views1 answer
Typical max-connect-errors mysql
SQL
4 votes368 views2 answers
Tsql utf to local time
SQL