22,209
社区成员
发帖
与我相关
我的任务
分享
if not object_id(N'Tempdb..#Tmp_A') is null
drop table #Tmp_A
Go
create table #Tmp_A
(
Module_No varchar(10),
Type_Code varchar(10))
INSERT INTO #Tmp_A
Select 'S1003', 'T1001' UNION all
Select 'S1003', 'TX002' UNION all
Select 'S1003', 'FX004' UNION all
Select 'L5E89', 'DF123' UNION all
Select 'L5E89', 'FF123'
Select Module_No, STUFF((select ','+Type_Code from #Tmp_A t where Module_No=t.Module_No for xml path('')), 1, 1, '')
From #Tmp_A
Group By Module_No
if OBJECT_ID('T1') is not null
drop table T1
Go
create table T1(
型号 varchar(20),
类别 varchar(20)
)
go
insert into T1(型号,类别)
select 'S1003','T1001' union all
select 'S1003','TX002' union all
select 'S1003','FX004' union all
select 'L5E89','DF123' union all
select 'L5E89','FF123'
go
select 型号, stuff((select ','+类别 from T1 t where 型号=T1.型号 for xml path('')), 1, 1, '') 结果 from T1
group by 型号 order by 型号 desc
/*
型号 结果
S1003 T1001,TX002,FX004
L5E89 DF123,FF123
*/