Concatenate grouped rows

by

Use:

select t.id, sum(t.price)
    , stuff((
        select distinct ',' + cast(t2.ServiceID as varchar(max))
        from @t t2
        where t2.id = t.id
        for xml path('')
    ), 1, 1, '')
from @t t
group by t.id

Output:

----------- --------------------- ---------------------
1           40,00                 11,12
2           120,00                11

More Related Contents:

  1. SQL: How can I get the value of an attribute in XML datatype?
  2. SQL Server SELECT to JSON function
  3. How can I query a value in SQL Server XML column
  4. Convert Xml to Table SQL Server
  5. Finding node order in XML document in SQL Server
  6. SQL Server FOR XML Path make repeating nodes
  7. I dont know sql syntax for my table [closed]
  8. How do I UPDATE from a SELECT in SQL Server?
  9. Get top 1 row of each group
  10. How to return only the Date from a SQL Server DateTime datatype
  11. CROSS JOIN vs INNER JOIN in SQL
  12. Referring to a Column Alias in a WHERE Clause
  13. Function vs. Stored Procedure in SQL Server
  14. Generate a resultset of incrementing dates in TSQL
  15. converting Epoch timestamp to sql server(human readable format)
  16. How do I split a delimited string so I can access individual items?
  17. Common Table Expression, why semicolon?
  18. What’s the best way to select the minimum value from several columns?
  19. T-SQL split string based on delimiter
  20. Counting DISTINCT over multiple columns
  21. Is there a performance difference between CTE , Sub-Query, Temporary Table or Table Variable?
  22. Why use Select Top 100 Percent?
  23. How to check if a stored procedure exists before creating it
  24. Correct use of transactions in SQL Server
  25. When can I save JSON or XML data in an SQL Table
  26. How to get the identity of an inserted row?
  27. How to create a pivot query in sql server without aggregate function
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. Replacing NULL and empty string within Select statement

Leave a Comment