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 vote119 views1 answer
Flexible search query delete table
SQL
1 vote103 views1 answer
How to delete a record from sqlite in android
SQL
0 vote126 views2 answers
Php convert dbf to mysql
SQL
2 votes151 views1 answer
Tcl in sql
SQL
3 votes111 views2 answers
Having in mysql
SQL
0 vote64 views1 answer
Mssql view column data type
SQL
4 votes116 views1 answer
Wilayah indonesia sql
SQL
0 vote102 views2 answers
Show slave status mysql
SQL
0 vote114 views1 answer
Template MySQL Zabbix agent
SQL
10 votes110 views2 answers
Tsql merge example
SQL