修改84价格的语句

wbv123

select * –case when stdprice=20 then 2 when stdprice=60 then 3 else 0 end ,stdprice,netprice, *
–into d_sale_c_bak0207
from u_sale_c where wareid=’100124′ and accdate>=’2020-01-21′
and (round((u_sale_c.wareqty + u_sale_c.minqty / u_sale_c.stdtomin) * u_sale_c.times ,4)>=30 or
round((u_sale_c.wareqty + u_sale_c.minqty / u_sale_c.stdtomin) * u_sale_c.times ,4)<=-30)

create table #disable_u_sale_c(id int)
update u_sale_c
set stdprice=2.5,netprice=2.5
from u_sale_c where wareid=’100124′ and accdate>=’2020-01-21′
and (round((u_sale_c.wareqty + u_sale_c.minqty / u_sale_c.stdtomin) * u_sale_c.times ,4)>=30 or
round((u_sale_c.wareqty + u_sale_c.minqty / u_sale_c.stdtomin) * u_sale_c.times ,4)<=-30)

drop table #disable_u_sale_c