22,207
社区成员
发帖
与我相关
我的任务
分享
create table A( A_ID int )
create table B( B_ID int ,A_id int,c_id int)
insert B values(1,1,1)
insert B values(2,2,1)
insert B values(3,1,2)
insert B values(4,2,2)
insert B values(5,3,2)
select * from A
select * from b
with tb as (select aa=STUFF((select '+'+cast(A_id as varchar(1)) from b zz
where zz.c_id=xx.c_id for xml path('')),1,1,'') from B xx
group by c_id)
select stuff((select ',' +aa from tb for xml path('')),1,1,'')
drop table a
drop table b
with tb as (select aa=STUFF((select '+'+cast(A_id as varchar(1)) from b zz
where zz.c_id=xx.c_id for xml path('')),1,1,'') from B xx
group by c_id)
select stuff((select ',' +aa from tb for xml path('')),1,1,'')
select c_id,aa=STUFF((select '+'+cast(A_id as varchar(1)) from b zz
where zz.c_id=xx.c_id for xml path('')),1,1,'') from B xx
group by c_id