Convert multiple rows into one with comma as separator [duplicate]

by 
 select
   distinct  
    stuff((
        select ',' + u.username
        from users u
        where u.username = username
        order by u.username
        for xml path('')
    ),1,1,'') as userlist
from users
group by username

had a typo before, the above works

More Related Contents:

  1. SQl CASE Statement
  2. Turning a Comma Separated string into individual rows
  3. How to calculate age in T-SQL with years, months, and days
  4. How can I use optional parameters in a T-SQL stored procedure?
  5. T-SQL Decimal Division Accuracy
  6. Selecting a Record With MAX Value
  7. How to convert Seconds to HH:MM:SS using T-SQL
  8. T-SQL: Selecting rows to delete via joins
  9. Where value in column containing comma delimited values
  10. Combining INSERT INTO and WITH/CTE
  11. What is a “batch”, and why is GO used?
  12. Getting the minimum of two values in SQL
  13. TSQL divide by zero encountered despite no columns containing 0
  14. T-SQL loop over query results
  15. How to insert default values in SQL table?
  16. How to Round a Time in T-SQL
  17. T-SQL CASE Clause: How to specify WHEN NULL
  18. t-sql get all dates between 2 dates [duplicate]
  19. Return a value if no rows are found in Microsoft tSQL
  20. Check if a varchar is a number (TSQL)
  21. Using Aliases in Where Clause or an Alternative Option?
  22. Extract the first word of a string in a SQL Server query
  23. T-SQL – function with default parameters
  24. Search for one value in any column of any table inside a database
  25. Check if a varchar is a number (T-SQL)
  26. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  27. Convert unix epoch timestamp to TSQL datetime
  28. T-SQL Between Dates Confusion
  29. Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row
  30. How to parse string into date?

Leave a Comment