What will be the query in MS Sql Server to concatenate my rows in one string , delimited by comma (Like shown below)
-
Which DBMS are you using? Oracle or SQL Server? And Have you tried something?atokpas– atokpas2017-01-22 06:06:31 +00:00Commented Jan 22, 2017 at 6:06
-
SQL SERVER, i have no idea how to do.....Ajit Kumar– Ajit Kumar2017-01-22 06:33:37 +00:00Commented Jan 22, 2017 at 6:33
-
1Please have a look here stackoverflow.com/q/194852/1530987Chandan Rai– Chandan Rai2017-01-22 06:46:19 +00:00Commented Jan 22, 2017 at 6:46
-
Please read How to Ask.Zohar Peled– Zohar Peled2017-01-22 08:07:13 +00:00Commented Jan 22, 2017 at 8:07
Add a comment
|
2 Answers
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
answered Jan 22, 2017 at 7:55
Comments
Assuming That your column name is NAME And table name is MYTABLE you can use the Following query:
DECLARE @strTemp VARCHAR(MAX)
SET @strTemp = ''
SELECT @strTemp = @strTemp + ISNULL(NAME,'') + ','
FROM MYTABLE
--Remove last comma
SET @strTemp = SUBSTRING(@strTemp ,1,LEN(@strTemp ) -1)
--Get Result
SELECT @strTemp
You can filter null records using the following
SELECT @strTemp = @strTemp + NAME + ','
FROM MYTABLE
WHERE NAME IS NOT NULL