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 1Are there any code examples left?
New code examples in category SQL
Relative searches
sql merge rows into one row in table
sql server merge join one row to multiple rows
join query to get multiple rows in one column
combine a column with a row sql
sql condense rows
how to merge two rows having same values into single row in sql
select multiple rows to one row sql
sql server get multiple row in columns
sql put two rows into one but not all columns
sql combine two rows into one
sql roll up rows into columns
