Can I Comma Delimit Multiple Rows Into One Column? [duplicate]

by

Here is a solution that works in SQL Server 2005+:

SELECT t.TicketID,
       STUFF(ISNULL((SELECT ', ' + x.Person
                FROM @Tickets x
               WHERE x.TicketID = t.TicketID
            GROUP BY x.Person
             FOR XML PATH (''), TYPE).value('.','VARCHAR(max)'), ''), 1, 2, '') [No Preceeding Comma],
       ISNULL((SELECT ', ' + x.Person
                FROM @Tickets x
               WHERE x.TicketID = t.TicketID
            GROUP BY x.Person
             FOR XML PATH (''), TYPE).value('.','VARCHAR(max)'), '') [Preceeding Comma If Not Empty]
  FROM @Tickets t
GROUP BY t.TicketID

Reference:

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. CROSS JOIN vs INNER JOIN in SQL
  3. Unpivot with column name
  4. How to generate a range of numbers between two numbers?
  5. SET versus SELECT when assigning variables?
  6. Multiple INSERT statements vs. single INSERT with multiple VALUES
  7. Convert varchar into datetime in SQL Server
  8. Generate Dates between date ranges
  9. Select statement to find duplicates on certain fields
  10. How to print VARCHAR(MAX) using Print Statement?
  11. Check if a row exists, otherwise insert
  12. T-SQL datetime rounded to nearest minute and nearest hours with using functions
  13. How to update Identity Column in SQL Server?
  14. Common Table Expression, why semicolon?
  15. T-SQL split string based on delimiter
  16. Concatenate values based on ID
  17. Splitting delimited values in a SQL column into multiple rows
  18. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  19. TransactSQL to run another TransactSQL script
  20. Store multiple bit values in a single table column
  21. Stored procedure that exports data into csv files only exports to one file
  22. How do I prevent a database trigger from recursing?
  23. SQL Server equivalent to MySQL enum data type?
  24. TSQL – How to use GO inside of a BEGIN .. END block?
  25. Using IF ELSE statement based on Count to execute different Insert statements
  26. How to combine results of two queries into a single dataset
  27. Executing SQL Server Agent Job from a stored procedure and returning job result
  28. SQL take just the numeric values from a varchar
  29. COALESCE Function in TSQL
  30. Using CASE Statement inside IN Clause

Leave a Comment