Try this method
DECLARE @EmployeeList varchar(8000)
SELECT @EmployeeList = COALESCE(@Emplo yeeList + ', ', '') + FirstName
FROM (
select 'Jose' as FirstName
union
select 'Haprise' as FirstName
)aa
SELECT @EmployeeList
BR
Ramkumar
Leave a comment: