GROUP BY to combine/concat a column [duplicate]

by 
SELECT
     [User], Activity,
     STUFF(
         (SELECT DISTINCT ',' + PageURL
          FROM TableName
          WHERE [User] = a.[User] AND Activity = a.Activity
          FOR XML PATH (''))
          , 1, 1, '')  AS URLList
FROM TableName AS a
GROUP BY [User], Activity

More Related Contents:

  1. sql group by only rows which are in sequence
  2. How to do a case sensitive GROUP BY?
  3. I dont know sql syntax for my table [closed]
  4. CROSS JOIN vs INNER JOIN in SQL
  5. How to cast the DateTime to Time
  6. How can I schedule a job to run a SQL query daily?
  7. How to generate a range of numbers between two numbers?
  8. Reset identity seed after deleting records in SQL Server
  9. How to avoid the “divide by zero” error in SQL?
  10. Multiple INSERT statements vs. single INSERT with multiple VALUES
  11. Generate Dates between date ranges
  12. Concat groups in SQL Server [duplicate]
  13. How to print VARCHAR(MAX) using Print Statement?
  14. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  15. How to update Identity Column in SQL Server?
  16. Concatenate values based on ID
  17. Splitting delimited values in a SQL column into multiple rows
  18. Detect consecutive dates ranges using SQL
  19. SQL GROUP BY CASE statement with aggregate function
  20. Split values over multiple rows [duplicate]
  21. How to do an inner join on row number in sql server
  22. Execute Dynamic Query with go in sql
  23. TransactSQL to run another TransactSQL script
  24. How can I get a list of element names from an XML value in SQL Server
  25. Stored procedure that exports data into csv files only exports to one file
  26. SQL Server: should I use information_schema tables over sys tables?
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. SQL take just the numeric values from a varchar
  29. Cumulative Total in MS Sql server [duplicate]
  30. SQL query to group by day

Leave a Comment