comma delimited list as a single string, T-SQL [duplicate]

by

You could use FOR XML PATH and STUFF to concatenate the multiple rows into a single row:

select distinct t1.id,
  STUFF(
         (SELECT ', ' + convert(varchar(10), t2.date, 120)
          FROM yourtable t2
          where t1.id = t2.id
          FOR XML PATH (''))
          , 1, 1, '')  AS date
from yourtable t1;

See SQL Fiddle with Demo

More Related Contents:

  1. Pad a string with leading zeros so it’s 3 characters long in SQL Server 2008
  2. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  3. Understanding PIVOT function in T-SQL
  4. How can I escape square brackets in a LIKE clause?
  5. Parameter Sniffing (or Spoofing) in SQL Server
  6. SQL Server String or binary data would be truncated
  7. Datatype for storing ip address in SQL Server
  8. How to change identity column values programmatically?
  9. SQL Server Regular expressions in T-SQL
  10. Is there a way to loop through a table variable in TSQL without using a cursor?
  11. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  12. How do I format a number with commas in T-SQL?
  13. Concatenating Column Values into a Comma-Separated List
  14. How to set a default value for an existing column
  15. Need a datetime column in SQL Server that automatically updates when the record is modified
  16. How do I find a stored procedure containing ?
  17. Return all possible combinations of values on columns in SQL
  18. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  19. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  20. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  21. Cannot bulk load. Operating system error code 5 (Access is denied.)
  22. Does query plan optimizer works well with joined/filtered table-valued functions?
  23. Is there an “IF EXISTS” test for a linked server?
  24. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  25. @@ERROR and/or TRY – CATCH
  26. “If not exists” fails on SQL CE
  27. Does the `nodes()` method keep the document order?
  28. Incorrect syntax near ‘)’ calling stored procedure with GETDATE
  29. Generate MD5 hash string with T-SQL
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment