SELECT * FROM LHDH201408

update LHDH201408 set 促销进价=原进价 where 促销进价 is null

update LHDH201408 set 促销配销价=促销进价 where 促销配销价 is null

update LHDH201408 set 公司让扣=0 where 公司让扣 is null

update LHDH201408 set 供应商让扣=0 where 供应商让扣 is null

ALTER TABLE LHDH201408 ADD 最终进价 decimal(8,4)

update LHDH201408 set 最终进价=促销配销价*(100-公司让扣-供应商让扣)/100

update LHDH201408 SET 商品编码=SUBSTRING(商品编码,2,6)