Hi ,

You can do as

declare @table as table

(id int)

INSERT INTO @table

SELECT 100 UNION ALL

SELECT 101 UNION ALL

SELECT 102 UNION ALL

SELECT 103 UNION ALL

SELECT 104

declare @output as varchar(max)

set @output='';

select @output=@output+','+cast(id as VARchar) FROM @table t1

select substring(@output,2,LEN(@output)-1) as Seq