游标，反复执行

2009-09-02 03:01:32 140 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

分析以太网帧结构_100G以太网接口调试初体验是的，标题没有多敲一个“0”，明人不说暗话，就是在FPGA上实现100G以太网接口设计。正好参与了实验室某项目中的100G接口的调试，早想写个专栏文章了，由于调试过程中发现了一些硬件问题，导致迟迟没有往前推进，现在问题解决了之后可以简单分享一下100G以太网接口的调试初体验了~（好像DDR4读写测试系列文章还没搞完）这篇初体验暂时不分多个章节了，基本设计流程与之前发布的“10G以太网接口”系列文... 阅读详情

写了一段语句，主要修改指定商品，指定日期的数据，但是现在想修改一时间段里的数据，请问怎么修改。
@oper_date指定的日期@item_no指定的商品，现在想修改一段时间的，例如8月1日至8月31日

declare @oper_date varchar(10),
@item_no varchar(20),
@branch_no varchar(2),
@sale_amt numeric(16,4)

select @oper_date = '2009-08-26'
select @item_no = '40002'

declare lcur_branch cursor for
select distinct left(branch_no,2) from t_rm_daysum where oper_date = @oper_date and item_no = @item_no

open lcur_branch
fetch lcur_branch into @branch_no
while @@fetch_status = 0
begin
--查找金额
select @sale_amt = 0
select @sale_amt = sum(sale_amt - ret_amt) from t_rm_daysum where item_no = @item_no and oper_date = @oper_date and left(branch_no,2) = @branch_no

--找最大金额来更新金额
if (@sale_amt is not null) and @sale_amt > 0
begin
update t_rm_casher_daysum set real_amt = real_amt - @sale_amt where oper_date = @oper_date and branch_no = left(@branch_no, 2)
and sale_way = 'A' and pay_way = 'RMB' and real_amt > @sale_amt
and casher_no = (select top 1 casher_no from t_rm_casher_daysum where oper_date = @oper_date and branch_no = left(@branch_no, 2)
and sale_way = 'A' and pay_way = 'RMB' and real_amt > @sale_amt order by real_amt desc)
end

fetch lcur_branch into @branch_no
end

close lcur_branch
deallocate lcur_branch

...全文

迪文屏【0】——从零搭建工程：图片显示、文本变量配置与串口数据交互实战本文以迪文屏T5L系列为例，详细介绍了从零搭建HMI工程的完整流程。内容涵盖硬件软件准备、DGUS工程创建、背景图片显示、文本变量配置，并重点演示了如何通过串口指令实时修改屏幕数据变量，实现动态交互。旨在帮助开发者快速掌握迪文屏开发的核心步骤与数据交互方法。阅读详情

fancydong

应用实例 27,579 成员 68,540 内容

+ 关注 + 加入社区

切换为时间正序

htl258_Tony 2009-09-02

打赏
举报

declare @oper_date varchar(10),  @oper_date2 varchar(10)

  @item_no varchar(20), 

  @branch_no varchar(2), 

  @sale_amt numeric(16,4) 



select @oper_date = '2009-08-01',@oper_date2 ='2009-08-31'

select @item_no = '40002' 



declare lcur_branch cursor for 

	select distinct left(branch_no,2) 

	from t_rm_daysum 

	where oper_date between @oper_date and @oper_date2 and item_no = @item_no 



open lcur_branch 

fetch lcur_branch into @branch_no 

while @@fetch_status = 0 

begin 

	--查找金额 

	select @sale_amt = 0 

	select @sale_amt = sum(sale_amt - ret_amt) 

	from t_rm_daysum 

	where item_no = @item_no 

		and oper_date between @oper_date and @oper_date2 

		and left(branch_no,2) = @branch_no 



	--找最大金额来更新金额 

	if (@sale_amt is not null) and @sale_amt > 0 

	begin 

		update t_rm_casher_daysum set 

			real_amt = real_amt - @sale_amt 

		where oper_date between @oper_date and @oper_date2

			and branch_no = left(@branch_no, 2) 

			and sale_way = 'A' and pay_way = 'RMB' and real_amt > @sale_amt 

			and casher_no = (

				select top 1 casher_no 

				from t_rm_casher_daysum 

				where oper_date between @oper_date and @oper_date2 and branch_no = left(@branch_no, 2) 

					and sale_way = 'A' and pay_way = 'RMB' and real_amt > @sale_amt 

				order by real_amt desc) 

	end 



	fetch lcur_branch into @branch_no 

end 



close lcur_branch 

deallocate lcur_branch

TRY.

华夏小卒 2009-09-02

打赏
举报



fetch next lcur_branch into @branch_no    --这个也要修改

华夏小卒 2009-09-02

打赏
举报



declare --@oper_date varchar(10), 

  @item_no varchar(20), 

  @branch_no varchar(2), 

  @sale_amt numeric(16,4),

  @start datetime,    --新增2个

  @end datetime       --新增



select @start='2009-08-01'      --新增

select @end='2009-08-31'        --新增

--select @oper_date = '2009-08-26' 

select @item_no = '40002' 



declare lcur_branch cursor for 

select distinct left(branch_no,2) from t_rm_daysum where oper_date between @start and @end and item_no = @item_no    --修改



--下面继续

......

lihan6415151528 2009-09-02

打赏
举报

[Quote=引用 11 楼 fancydong 的回复:]
情况比较复杂点，所以用了游标

[/Quote]

复杂到什么程度了？

zhangwonderful 2009-09-02

打赏
举报

可以将游标改成如下语句，实现时间段查询过滤
declare lcur_branch cursor for
select distinct left(branch_no,2) from t_rm_daysum where oper_date between @oper_begin_date and @oper_end_date and item_no = @item_no

soft_wsx 2009-09-02

打赏
举报

[Quote=引用 12 楼 jinfengyiye 的回复:]
where 日期 between '2009-08-01' and '2009-08-31'?
[/Quote]是呀！指定时间段的！
最好弄点数据出来

gw6328 2009-09-02

打赏
举报

where 日期 between '2009-08-01' and '2009-08-31'?

fancydong 2009-09-02

打赏
举报

情况比较复杂点，所以用了游标

gw6328 2009-09-02

打赏
举报

帮顶个

fancydong 2009-09-02

打赏
举报

日期指定为2009-08-01至2009-08-31

htl258_Tony 2009-09-02

打赏
举报

一定要用游标实现吗?

fancydong 2009-09-02

打赏
举报

语句，不能改变语句里的效果，是按照每天来冲减的

jwdream2008 2009-09-02

打赏
举报

end 



fetch next from lcur_branch into @branch_no 



end 



close lcur_branch 

deallocate lcur_branch

soft_wsx 2009-09-02

打赏
举报

没有必要用游标！给点数据

fancydong 2009-09-02

打赏
举报

？
时间段怎么加进去

jwdream2008 2009-09-02

打赏
举报

[Quote=引用 2 楼 lass_name 的回复:]
SQL codefetch lcur_branchinto@branch_no
修改fetchnextfrom lcur_branchinto@branch_no
[/Quote]
顶！

lass_name 2009-09-02

打赏
举报



fetch lcur_branch into @branch_no 

修改

fetch next from lcur_branch into @branch_no

guguda2008 2009-09-02

打赏
举报

加个WHERE不就行了

游标，反复执行

相关推荐