Concat groups in SQL Server [duplicate]

by

For a clean and efficient solution you can create an user defined aggregate function, there is even an example that does just what you need.
You can then use it like any other aggregate function (with a standard query plan):

query plan

More Related Contents:

  1. How to concatenate text from multiple rows into a single text string in SQL Server
  2. How to use GROUP BY to concatenate strings in SQL Server?
  3. How to create a SQL Server function to “join” multiple rows from a subquery into a single delimited field? [duplicate]
  4. SQL NVARCHAR and VARCHAR Limits
  5. GROUP BY to combine/concat a column [duplicate]
  6. SQL GROUP BY CASE statement with aggregate function
  7. sql group by only rows which are in sequence
  8. How to return a incremental group number per group in SQL
  9. SQL query to group by day
  10. Conversion failed when converting the varchar value ‘simple, ‘ to data type int
  11. How to group by a Calculated Field
  12. How to do a case sensitive GROUP BY?
  13. NOT IN vs NOT EXISTS
  14. Only inserting a row if it’s not already there
  15. How to concatenate strings of a string field in a PostgreSQL ‘group by’ query?
  16. Most efficient way in SQL Server to get date from date+time?
  17. When no ‘Order by’ is specified, what order does a query choose for your record set?
  18. How do I create a step in my SQL Server Agent Job which will run my SSIS package?
  19. SQL Call Stored Procedure for each Row without using a cursor
  20. How to select the last record of a table in SQL?
  21. How do I group on continuous ranges
  22. join comma delimited data column
  23. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  24. Get previous and next row from rows selected with (WHERE) conditions
  25. How to list files inside a folder with SQL Server
  26. Can SQL Server Express LocalDB be connected to remotely?
  27. Is there a severe performance hit for using Foreign Keys in SQL Server?
  28. How can I find Unicode/non-ASCII characters in an NTEXT field in a SQL Server 2005 table?
  29. Date serial in SQL?
  30. Parameterise table name in .NET/SQL?

Leave a Comment