SQL: Aggregating strings together

by 
WITH Data AS (
    SELECT 1 UserId, 'A' Code 
    UNION ALL 
    SELECT 1, 'C5'
    UNION ALL 
    SELECT 1, 'X'
    UNION ALL 
    SELECT 2, 'V3'
    UNION ALL 
    SELECT 3, 'B'
    UNION ALL 
    SELECT 3, 'D'
    UNION ALL 
    SELECT 3, NULL
    UNION ALL 
    SELECT 3, 'F4'
    UNION ALL 
    SELECT 4, NULL
)
SELECT U.UserId, STUFF((
    SELECT ','+Code FROM Data WHERE Data.UserID = U.UserID FOR XML PATH('')
), 1, 1, '') Code 
FROM (SELECT DISTINCT UserID FROM Data) U

Just replace the Data CTE with your table name and you’re done.

More Related Contents:

  1. Get top 1 row of each group
  2. SQL update query using joins
  3. Referring to a Column Alias in a WHERE Clause
  4. SQL query to select dates between two dates
  5. Selecting COUNT(*) with DISTINCT
  6. Querying data by joining two tables in two database on different servers
  7. Generate a resultset of incrementing dates in TSQL
  8. Real life example, when to use OUTER / CROSS APPLY in SQL
  9. Getting result of dynamic SQL into a variable for sql-server
  10. How to get difference between two rows for a column field?
  11. Better techniques for trimming leading zeros in SQL Server?
  12. Select info from table where row has max date
  13. Sql Server equivalent of a COUNTIF aggregate function
  14. Dynamic SELECT TOP @var In SQL Server
  15. What’s the best way to select the minimum value from several columns?
  16. Is the LIKE operator case-sensitive with SQL Server?
  17. Hierarchical data in Linq – options and performance
  18. How to connect to SQL Server from another computer?
  19. How to convert comma separated NVARCHAR to table records in SQL Server 2005?
  20. How to insert a blob into a database using sql server management studio
  21. How to check which locks are held on a table
  22. Execution sequence of Group By, Having and Where clause in SQL Server?
  23. Cross Join without duplicate combinations
  24. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  25. How to find sum of multiple columns in a table in SQL Server 2005?
  26. SQL Script to alter ALL Foreign Keys to add ON DELETE CASCADE
  27. Query times out from web app but runs fine from management studio
  28. SQL . The SP or function should calculate the next date for friday
  29. SQL Combine Two Columns in Select Statement
  30. Querying Active Directory from SQL Server 2005

Leave a Comment