sql server get Comma Separated Values in SQL

declare @tbl table

(id int,

siteid int,

sectionid int

)

insert into @tbl

select 706029,125443,128322

union all

select 706044,125444,128323

union all

select 706044,125444,128370

select * from @tbl

select id,siteid,substring ((select ','+cast(sectionid as varchar(100)) from @tbl a where a.siteid=b.siteid for xml path('') ),2,100 ) as sectionid

from @tbl b

group by id,siteid