SQL Server : GROUP BY clause to get comma-separated values [duplicate]

by

try this:

SELECT ReportId, Email = 
    STUFF((SELECT ', ' + Email
           FROM your_table b 
           WHERE b.ReportId = a.ReportId 
          FOR XML PATH('')), 1, 2, '')
FROM your_table a
GROUP BY ReportId

SQL fiddle demo

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Insert local .csv data in remote SQL Server via already working connection string
  3. Syntax combine two stored procedure into one [closed]
  4. How to delete duplicate rows in SQL Server?
  5. CROSS JOIN vs INNER JOIN in SQL
  6. How to cast the DateTime to Time
  7. How to update Identity Column in SQL Server?
  8. Concatenate values based on ID
  9. How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
  10. What is the order of execution for this SQL statement
  11. Splitting delimited values in a SQL column into multiple rows
  12. How to import text files with the same name and schema but different directories into database?
  13. Detect consecutive dates ranges using SQL
  14. Select a Column in SQL not in Group By
  15. Split values over multiple rows [duplicate]
  16. How to do an inner join on row number in sql server
  17. How can I alter this computed column in SQL Server 2008?
  18. Stored procedure that exports data into csv files only exports to one file
  19. SQL Server: should I use information_schema tables over sys tables?
  20. TSQL – How to use GO inside of a BEGIN .. END block?
  21. SQL take just the numeric values from a varchar
  22. How do I change db schema to dbo
  23. Count records for every month in a year
  24. How to export data from Excel spreadsheet to Sql Server 2008 table
  25. SQL Server: +(unary) operator on non-numeric Strings
  26. Use one CTE many times
  27. Bulk insert using stored procedure
  28. Connect different Windows User in SQL Server Management Studio (2005 or later)
  29. How to Select Every Row Where Column Value is NOT Distinct
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment