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

2 votes128 views2 answers
Useradd postgres
SQL
0 vote130 views1 answer
How should I pass a table name into a stored proc?
SQL
0 vote129 views1 answer
How to increase the width of the screen in oracle
SQL
2 votes118 views2 answers
Oracle create table if not exists
SQL
0 vote133 views1 answer
Convert .mdf to .bak
SQL
0 vote137 views1 answer
Delete duplicate rows
SQL
0 vote152 views1 answer
Alling a function from PL/SQL in a select statement in ORACLE
SQL
5 votes134 views3 answers
Mysql remove unique constraint
SQL
36 votes250 views6 answers
Change column data type sql
SQL
2 votes132 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL