Grouped string aggregation / LISTAGG for SQL Server

by

http://www.simple-talk.com/sql/t-sql-programming/concatenating-row-values-in-transact-sql/

It is an interesting problem in Transact SQL, for which there are a number of solutions and considerable debate. How do you go about producing a summary result in which a distinguishing column from each row in each particular category is listed in a ‘aggregate’ column? A simple, and intuitive way of displaying data is surprisingly difficult to achieve. Anith Sen gives a summary of different ways, and offers words of caution over the one you choose…

More Related Contents:

  1. Optimal way to concatenate/aggregate strings
  2. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  3. The SQL OVER() clause – when and why is it useful?
  4. Group DateTime into 5,15,30 and 60 minute intervals
  5. SQL comma-separated row with Group By clause
  6. Get Parent with multiple children in desc order
  7. How to calculate age (in years) based on Date of Birth and getDate()
  8. How can I schedule a job to run a SQL query daily?
  9. Convert Month Number to Month Name Function in SQL
  10. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  11. Limit on the WHERE col IN (…) condition
  12. Removing leading zeroes from a field in a SQL statement
  13. Get day of week in SQL Server 2005/2008
  14. Getting result of dynamic SQL into a variable for sql-server
  15. How to get difference between two rows for a column field?
  16. Simple Query to Grab Max Value for each ID
  17. SQL Server: Extract Table Meta-Data (description, fields and their data types)
  18. SQL Server 2008: how do I grant privileges to a username?
  19. SQL Server SELECT into existing table
  20. Dynamic Pivot Table in SQL Server
  21. Optimized SQL for tree structures
  22. How to insert a blob into a database using sql server management studio
  23. CHECK CONSTRAINT on multiple columns
  24. Insert Update stored proc on SQL Server
  25. SQL count consecutive days
  26. TSQL – How to use GO inside of a BEGIN .. END block?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  29. How to get the next number in a sequence
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment