get a comma delimited string from rows [duplicate]

by

Use STUFF and FOR XML:

Create and populate sample table (Please save us this step in your future questions)

DECLARE @T AS TABLE
(
    Name varchar(10)
)

INSERT INTO @T VALUES
('John'),
('Vicky'),
('Sham'),
('Anjli'),
('Manish')

The query:

SELECT STUFF((
    SELECT ',' + Name
    FROM @T
    FOR XML PATH('')
), 1, 1, '') As [output];

Results:

output
John,Vicky,Sham,Anjli,Manish

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Scope of temporary tables in SQL Server
  3. Sequence vs identity
  4. Count Number of Consecutive Occurrence of values in Table
  5. How to correctly insert newline in nvarchar [duplicate]
  6. Find min and max for subsets of consecutive rows – gaps and islands
  7. How to get Previous Value for Null Values
  8. SQL Server: +(unary) operator on non-numeric Strings
  9. How to calculate age (in years) based on Date of Birth and getDate()
  10. Convert Month Number to Month Name Function in SQL
  11. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  12. SET versus SELECT when assigning variables?
  13. T-SQL dynamic pivot
  14. Avoid duplicates in INSERT INTO SELECT query in SQL Server
  15. Generate Dates between date ranges
  16. Select group of rows that match all items in a list
  17. How to print VARCHAR(MAX) using Print Statement?
  18. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  19. Query error with ambiguous column name in SQL
  20. Why (and how) to split column using master..spt_values?
  21. Splitting delimited values in a SQL column into multiple rows
  22. What does =* mean?
  23. SQL: parse the first, middle and last name from a fullname field
  24. SQL Select Upcoming Birthdays
  25. How can I include null values in a MIN or MAX?
  26. Get the last day of the month in SQL
  27. TSQL – How to use GO inside of a BEGIN .. END block?
  28. SQL take just the numeric values from a varchar
  29. SQL – How do I get only the numbers after the decimal?
  30. How to retrieve records for last 30 minutes in MS SQL?

Leave a Comment