毛利率分类自动执行商品资料

wbv123

update u_ware_class set classcode =(case when (saleprice -purprice)/saleprice> 0.7 then ’01′(01类别70%以上）
when (saleprice -purprice)/saleprice> 0.5 and (saleprice -purprice)/saleprice<= 0.7 then ’02’（02类别70%-50%） when (saleprice -purprice)/saleprice> 0.4 and (saleprice -purprice)/saleprice<= 0.5 then ’03’ when (saleprice -purprice)/saleprice> 0.2 and (saleprice -purprice)/saleprice<= 0.4 then ’04’ when (saleprice -purprice)/saleprice> 0.1 and (saleprice -purprice)/saleprice<= 0.2 then ’05’ when (saleprice -purprice)/saleprice>= 0 and (saleprice -purprice)/saleprice<= 0.1 then ’06’（06类别0-10%） else ’10’ end （剩余全为10类别） ) from u_ware_class ,u_ware_q where u_ware_class.wareid =u_ware_q.wareid and u_ware_class.parentcode =’31’ and u_ware_q.saleprice <>0
–and u_ware_q.wareid in (select wareid from d_ware_class20201230) （大分类为31）

（下面是个例子）

update u_ware_class set classcode =(case when (saleprice -purprice)/saleprice> 0.7 then ’01’
when (saleprice -purprice)/saleprice> 0.5 and (saleprice -purprice)/saleprice<= 0.7 then ’02’ when (saleprice -purprice)/saleprice>= 0.1 and (saleprice -purprice)/saleprice<= 0.5 then ’03’ else ’10’ end ) from u_ware_class ,u_ware_q where u_ware_class.wareid =u_ware_q.wareid and u_ware_class.parentcode =’11’ and u_ware_q.saleprice <>0