我现在有一表1:
CPBM BM1 SL1 BM2 SL2 BM3 SL3 BM4 SL4
XXXX AA A1 BB B1 CC C1 DD D1
ASAS SA DS SA AS AS AS AS AS
ASDSA ASA ASA AS AS DS AS AS AS
CPBM BM1 SL1 BM2 SL2 BM3 SL3 BM4 SL4
XXXX AA A1 BB B1 CC C1 DD D1
ASAS SA DS SA AS AS AS AS AS
ASDSA ASA ASA AS AS DS AS AS AS
BM SL
AA A1
BB B1
CC C1
DD D1
先谢谢大家热心帮助
(
CPBM nvarchar(30),
BM1 nvarchar(30),
SL1 nvarchar(30),
BM2 nvarchar(30),
SL2 nvarchar(30),
BM3 nvarchar(30),
SL3 nvarchar(30),
BM4 nvarchar(30),
SL4 nvarchar(30)
)
insert into #TT select 'XXXX','AA','A1','BB','B1','CC','C1','DD','D1'
insert into #TT select 'ASAS','SA','DS','SA','AS','AS','AS','AS','AS'select Col1,Col2 from
(
select CPBM,BM1 as Col1,SL1 as Col2 from #TT
union all
select CPBM,BM2,SL2 from #TT
union all
select CPBM,BM3,SL3 from #TT
union all
select CPBM,BM4,SL4 from #TT
)TT
where CPBM='XXXX'
Col1 Col2
------------------------------ ------------------------------
AA A1
BB B1
CC C1
DD D1(4 行受影响)