Concatenate values based on ID

by

You can not be sure about the order of the strings concatenated without an order by statement in the sub query. The .value('.', 'varchar(max)') part is there to handle the case where Label contains XML-unfriendly characters like &.

declare @T table(Response_ID int, Label varchar(50))
insert into @T values
(12147,          'It was not clear'),
(12458,          'Did not Undersstand'),
(12458,          'Was not resolved'),
(12458,          'Did not communicate'),
(12586,          'Spoke too fast'),
(12587,          'Too slow')

select T1.Response_ID,
       stuff((select ','+T2.Label
              from @T as T2
              where T1.Response_ID = T2.Response_ID
              for xml path(''), type).value('.', 'varchar(max)'), 1, 1, '') as Label
from @T as T1
group by T1.Response_ID

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. SET versus SELECT when assigning variables?
  3. How to print VARCHAR(MAX) using Print Statement?
  4. Splitting delimited values in a SQL column into multiple rows
  5. Cumulative Total in MS Sql server [duplicate]
  6. I dont know sql syntax for my table [closed]
  7. Get top 1 row of each group
  8. CROSS JOIN vs INNER JOIN in SQL
  9. Referring to a Column Alias in a WHERE Clause
  10. Convert Month Number to Month Name Function in SQL
  11. How to avoid the “divide by zero” error in SQL?
  12. Multiple INSERT statements vs. single INSERT with multiple VALUES
  13. Generate a resultset of incrementing dates in TSQL
  14. Real life example, when to use OUTER / CROSS APPLY in SQL
  15. Getting result of dynamic SQL into a variable for sql-server
  16. How to get difference between two rows for a column field?
  17. Better techniques for trimming leading zeros in SQL Server?
  18. How to update Identity Column in SQL Server?
  19. Common Table Expression, why semicolon?
  20. What’s the best way to select the minimum value from several columns?
  21. T-SQL split string based on delimiter
  22. varbinary to string on SQL Server
  23. Restrict an SQL Server connection to a specific IP address
  24. SQL Server 2005 ROW_NUMBER() without ORDER BY
  25. Can an INNER JOIN offer better performance than EXISTS
  26. Stored procedure that exports data into csv files only exports to one file
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. SQL take just the numeric values from a varchar
  29. COALESCE Function in TSQL
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment