sql roll up rows into columns

Solutions on MaxInterview for sql roll up rows into columns by the best coders in the world

showing results for - "sql roll up rows into columns"

1SELECT 
2   SS.SEC_NAME,
3   STUFF((SELECT '; ' + US.USR_NAME 
4          FROM USRS US
5          WHERE US.SEC_ID = SS.SEC_ID
6          ORDER BY USR_NAME
7          FOR XML PATH('')), 1, 1, '') [SECTORS/USERS]
8FROM SALES_SECTORS SS
9GROUP BY SS.SEC_ID, SS.SEC_NAME
10ORDER BY 1

similar questions

convert rows to columns in sql server how to use row number function in sql server sql rownum update values in select statement sql how to select a row in sql create row number in sql change row in sql select top 10 rows in sql how to update values in sql how to update row in sql convert multiple columns to rows in sql server sql update subtract value 1 column values in to 1 single row in sql how to change the value of a table in sql sql pivot rows to columns updating values in sql sql create text column limited values rownum in sql how to update random rows in sql

queries leading to this page

sql server merge join one row to multiple rows sql merge rows into one row in table sql combine two rows into one sql condense rows select multiple rows to one row sql sql put two rows into one but not all columns sql roll up rows into columns how to merge two rows having same values into single row in sql join query to get multiple rows in one column sql server get multiple row in columns combine a column with a row sql sql roll up rows into columns