22,209
社区成员
发帖
与我相关
我的任务
分享
create table BBB2
(
ID int, --主键
订单号 nvarchar(50),
颜色 nvarchar(50),
尺码 nvarchar(50) ,
数量 int ,
单位 nvarchar(50) ,
)
go
insert into AAA2 values(1,'A001','黑色','M',10,'套')
insert into AAA2 values(2,'A001','白色','M',20,'套')
insert into AAA2 values(3,'A001','黑色','L',30,'套')
insert into AAA2 values(4,'A001','兰色','L',40,'件')
insert into AAA2 values(5,'A001','白色','XL',50,'套')
insert into AAA2 values(6,'A002','黑色','M',10,'套')
insert into AAA2 values(7,'A002','白色','M',20,'套')
insert into AAA2 values(8,'A002','黑色','L',30,'套')
insert into AAA2 values(9,'A003','兰色','L',40,'套')
insert into AAA2 values(10,'A003','白色','XL',50,'套')
Insert into bbb2 (ID,订单号,颜色,尺码,数量,单位)
select ID,订单号,颜色,尺码,数量,单位 FROM AAA2 WHERE 单位='套'
Insert into bbb2 (ID,订单号,颜色,尺码,数量,单位)
select ID,订单号,颜色,尺码,数量,单位 FROM AAA2 WHERE 单位<>'套'
Insert into bbb2 (ID,订单号,颜色,尺码,数量,单位)
SELECT ID,订单号,颜色,尺码,数量,'衣+件' FROM AAA2 WHERE 单位='套'
UNION ALL
select ID,订单号,颜色,尺码,数量,'库+条' FROM AAA2 WHERE 单位='套'