之前是这种效果,
要变成这种效果
select b.id,left(userlist,len(userlist)-1) as paths from(
select id,(
select userid+',' from test2 where id=a.id order by id for xml path(''))
as userlist
from test2 a
group by id
)b
之前是这种效果,
要变成这种效果
select b.id,left(userlist,len(userlist)-1) as paths from(
select id,(
select userid+',' from test2 where id=a.id order by id for xml path(''))
as userlist
from test2 a
group by id
)b