急求一份 WEB 系统毕业设计 随便什么系统都行 JSP 和SQL
求详细发邮箱1201_jun@sina.com不胜感激有WORD更好用ASP.NET编写...
求详细 发邮箱 1201_jun@sina.com 不胜感激 有WORD 更好
用ASP.NET 编写 展开
用ASP.NET 编写 展开
3个回答
展开全部
for cust_id in (select cust_code from ec_CLONE_cgt_co_detail where cgt_code='6901028225137')
loop
update ec_CLONE_cgt_co_detail set ord_qty=round(ord_qty*0.93,0)
where cgt_code='6901028225137' and co_num in (select co_num from ec_CLONE_cgt_co where org_code ='11340101'
and order_date =(select distinct replace (varchar(current date) ,'-','') from ec_CLONE_cgt_co))
and cust_code=cust_id.cust_code;
end loop;
commit;
END IF;
END;
loop
update ec_CLONE_cgt_co_detail set ord_qty=round(ord_qty*0.93,0)
where cgt_code='6901028225137' and co_num in (select co_num from ec_CLONE_cgt_co where org_code ='11340101'
and order_date =(select distinct replace (varchar(current date) ,'-','') from ec_CLONE_cgt_co))
and cust_code=cust_id.cust_code;
end loop;
commit;
END IF;
END;
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询