group_concat in sql server

Declare @t table(SNo int identity,name varchar(50))

Insert Into @t 

select 'AA' Union All select 'BB' Union All select 'CC' Union All

select 'DD' Union All select 'EE'



Select Name  = stuff((Select ',' + CAST(name as varchar(100))

From @t

for xml path('')),1,1,'')

output

Name

AA,BB,CC,DD,EE

Best Regards,
Niladri Biswas

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

Declare @t table(SNo int identity,name varchar(50))

Insert Into @t 

select 'AA' Union All select 'BB' Union All select 'CC' Union All

select 'DD' Union All select 'EE'



Declare @assignTo nvarchar(4000)

select @assignTo = Coalesce(@assignTo + ',', '') + CAST(Name as nvarchar(250)) 

from @t

select Name = @assignto

output

Name

AA,BB,CC,DD,EE

Best Regards,
Niladri Biswas

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator

You can use the below steps:-

1. Create a table Value and store all values to this table.
2. Below are the different queries:-

Query 1: Using "COALESCE" function

DECLARE @temp VARCHAR(MAX)
SELECT @temp = COALESCE(@temp+', ' ,'') + val
FROM [dbo].[Value]
SELECT @temp

Query 2: Using without "COALESCE" function

DECLARE @temp VARCHAR(MAX)
SET @temp = ''
SELECT @temp = @temp + val + ', '
FROM [dbo].[Value]
SELECT SUBSTRING(@temp, 0, LEN(@temp))

Query 3: Using "FOR XML PATH"

DECLARE @temp VARCHAR(MAX)
SET @temp = (SELECT ', ' + cast(s.val as varchar)
FROM [dbo].[Value] s
ORDER BY s.state
FOR XML PATH(''))
SELECT SUBSTRING(@temp, 2, 200000) AS state

Hope this will help you.

Murugavelmsc, if this helps please login to Mark As Answer. | Alert Moderator