SQL Server – join rows into comma separated list

by

You are missing the condition inside the sub query.

SELECT t2.Id, STUFF((SELECT ',' + CAST(VALUE AS varchar) FROM @MyTable t1  where t1.Id =t2.ID FOR XML PATH('')), 1 ,1, '') AS ValueList
FROM @MyTable t2
GROUP BY t2.Id

Demo

More Related Contents:

  1. Turning a Comma Separated string into individual rows
  2. How to split a comma-separated value to columns
  3. How to export data as CSV format from SQL Server using sqlcmd?
  4. The order of a SQL Select statement without Order By clause
  5. Select columns from result set of stored procedure
  6. SQL Server: SELECT only the rows with MAX(DATE)
  7. Import Multiple CSV Files to SQL Server from a Folder
  8. Bulk Insert Partially Quoted CSV File in SQL Server
  9. SQL Server Bulk insert of CSV file with inconsistent quotes
  10. Export table to file with column headers (column names) using the bcp utility and SQL Server 2008
  11. How can I import an Excel file into SQL Server? [closed]
  12. What does “ORDER BY (SELECT NULL)” mean?
  13. Taking the second last row with only one select in SQL Server?
  14. How to get the last row from a table in SQL Server?
  15. Storing a file in a database as opposed to the file system?
  16. Preferred Method of Storing Passwords In Database
  17. How do you count the number of occurrences of a certain substring in a SQL varchar?
  18. Why is it considered bad practice to use cursors in SQL Server?
  19. Import Excel spreadsheet columns into SQL Server database
  20. Hitting the 2100 parameter limit (SQL Server) when using Contains()
  21. How do I search an SQL Server database for a string?
  22. Fastest way to determine if record exists
  23. WHERE clause on SQL Server “Text” data type
  24. SQL Server – parameter sniffing
  25. Does the order of columns in a WHERE clause matter?
  26. SQL Rows to Columns
  27. What is the best way to implement Polymorphic Association in SQL Server?
  28. Set option 9 in SQL Server stored procedure using WinHttp.WinHttpRequest.5.1 for TLS 1.2
  29. How to generate auto increment field in select query
  30. How to maintain the order of insertion in SQL Server

Leave a Comment