How to get comma separated value..?

Question

My query is

select ContactId from dbo.ContactGroupReln where ContactGroupId=@ContactGroupId

through this query i want to get the comma separated list..Can any body help me pls..

Answer 1

Here is another simple of doing this.

DECLARE @listContactIdStr VARCHAR(MAX)
select  @listContactIdStr = COALESCE(@listContactIdStr+',' ,'') +ContactId from dbo.ContactGroupReln where ContactGroupId=@ContactGroupId

SELECT @listContactIdStr

Please let me know, if it is not helping you.

Answer 2

Please check this link and try the query out there http://www.c-sharpcorner.com/UploadFile/ff2f08/comma-separated-value-in-sql-query/