Answers for "sql roll up rows into columns"

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

Posted by: Guest on November-11-2020

Code answers related to "sql roll up rows into columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql roll up rows into columns"

Code answers related to "sql roll up rows into columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Answers for "sql roll up rows into columns"

Code answers related to "sql roll up rows into columns"

Code answers related to "SQL"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us