SQL comma-separated row with Group By clause

by

You want to use FOR XML PATH construct:

SELECT ACCOUNT, 
       unit, 
       SUM(state_fee), 
       Stuff((SELECT ', ' + code 
              FROM   tblmta t2 
              WHERE  t2.ACCOUNT = t1.ACCOUNT 
                     AND t2.unit = t1.unit 
                     AND t2.id = '123' 
              FOR XML PATH('')), 1, 2, '') [Codes] 
FROM   tblmta t1 
WHERE  t1.id = '123' 
GROUP  BY ACCOUNT, 
          unit

See other examples here:

More Related Contents:

  1. SQL Query to get aggregated result in comma separators along with group by column in SQL Server
  2. SQL, How to Concatenate results?
  3. Insert an image in a column of a table that already has 5 columns
  4. Get top 1 row of each group
  5. Referring to a Column Alias in a WHERE Clause
  6. How to SELECT FROM stored procedure
  7. Convert Month Number to Month Name Function in SQL
  8. How to avoid the “divide by zero” error in SQL?
  9. Generate a resultset of incrementing dates in TSQL
  10. Real life example, when to use OUTER / CROSS APPLY in SQL
  11. Getting result of dynamic SQL into a variable for sql-server
  12. How to get difference between two rows for a column field?
  13. Better techniques for trimming leading zeros in SQL Server?
  14. What’s the best way to select the minimum value from several columns?
  15. Concatenate values based on ID
  16. Splitting delimited values in a SQL column into multiple rows
  17. varbinary to string on SQL Server
  18. SQL : in clause in stored procedure:how to pass values
  19. How to insert a blob into a database using sql server management studio
  20. SQL GROUP BY CASE statement with aggregate function
  21. separate comma separated values and store in table in sql server
  22. Best way to do nested case statement logic in 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. How to compare dates in SQL Server
  27. How do I expand comma separated values into separate rows using SQL Server 2005?
  28. Is there a quick way to check if ANY column is NULL?
  29. Why do SQL Server Scalar-valued functions get slower?
  30. SQL query for parent-child chain

Leave a Comment