Vb.net Development and SQL Hints

Tuesday, 25 February 2020

Rolling up Multiple Rows into a Single Row (STUFF)

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 kanakaraj at 03:32 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

About Me

kanakaraj
View my complete profile

Blog Archive

  • ►  2021 (1)
    • ►  July (1)
  • ▼  2020 (3)
    • ►  May (1)
    • ►  March (1)
    • ▼  February (1)
      • Rolling up Multiple Rows into a Single Row (STUFF)
  • ►  2019 (7)
    • ►  November (7)
  • ►  2017 (12)
    • ►  August (1)
    • ►  June (3)
    • ►  May (4)
    • ►  April (3)
    • ►  March (1)
  • ►  2016 (14)
    • ►  December (2)
    • ►  November (2)
    • ►  October (10)
Watermark theme. Powered by Blogger.