[SQLServer]将多条记要的一个字段进行连接

[SQLServer]将多条记录的一个字段进行连接
for xml path('root')

select tt.organization_id, left(list,len(list)-1) from (   select t.organization_id,(    select cast(party_id as varchar) + ','       from hrs_employee for xml path('')   ) as list   from hrs_employee t group by t.organization_id) tt

1    0,0,1,1,8000001000002,8000001000003
99   0,0,1,1,8000001000002,8000001000003