问一个关于游标的问题在线等 解决马上结帖子

[dcren118]

declare rpt cursor for
select (select Sum(a.price * a.FConvert) as ProductSum from vw_StoreProductInDetail a where a.BillNumber = b.BillNumber) as ProductSum,
(select Sum(c.WareSum) as WareSum from WarehouseDetail c where c.DetailBill = b.BillNumber) as WareSum
from vw_StoreProductIn b where b.OperateTypeID='''10'''

declare @ProductSum decimal,
@WareSum decimal
open rpt
fetch next from rpt into @ProductSum,@WareSum
while @@fetch_status =0
Begin
--print @ProductSum
set @TopAllSum = @TopAllSum + @ProductSum - @WareSum
fetch next from rpt into @ProductSum,@WareSum
End
close rpt -- 结束后关闭游标
deallocate rpt
print @TopAllSum
这个游标返回的结果是空的 高手帮忙看看那里错了 ？？？ 游标不能这么用么 ？？？

[wshuangminlg]

帮LZ

[cpp2017]

declare @ProductSum decimal, @WareSum decimal ==> declare @ProductSum decimal, @WareSum decimal set @ProductSum = 0 set @WareSum = 0

[dcren118]

还是不行呢 ！

我这里面的两个值是 上面 SELECT 语句里面的
select (select Sum(a.price * a.FConvert) as ProductSum from vw_StoreProductInDetail a where a.BillNumber = b.BillNumber) as ProductSum,
(select Sum(c.WareSum) as WareSum from WarehouseDetail c where c.DetailBill = b.BillNumber) as WareSum
from vw_StoreProductIn b where b.OperateTypeID='''10'''
这里面的返回的值 然后累加付给 @TopAllSum 最后在用@TopAllSum干其他事情 ！

[KIEKI-LEO]

你的这个变量'@TopAllSum'放在begin...end中能不能输出值？？
我在怀疑是你变量作用域的问题哦

[dcren118]

那有什么方法能解决这里累加的问题么 ？？ 谢谢 ！

[cpp2017]

TopAllSum 也要初始化

[KIEKI-LEO]

declare @ProductSum decimal,
@WareSum decimal，
@TopAllSum decimal

declare rpt cursor for
select (select Sum(a.price * a.FConvert) as ProductSum from vw_StoreProductInDetail a where a.BillNumber = b.BillNumber) as ProductSum,
(select Sum(c.WareSum) as WareSum from WarehouseDetail c where c.DetailBill = b.BillNumber) as WareSum
from vw_StoreProductIn b where b.OperateTypeID='''10'''

open rpt
fetch next from rpt into @ProductSum,@WareSum
while @@fetch_status =0
Begin
--print @ProductSum
set @TopAllSum = @TopAllSum + @ProductSum - @WareSum
fetch next from rpt into @ProductSum,@WareSum
End
close rpt -- 结束后关闭游标
deallocate rpt
print @TopAllSum
你这样再试试。不保证正确..语法现在是没错了。如果还不行的话。那就看看你查询那快查出的数据对不对先试着把@TopAllSum在begin..end之间输出看结果。然后把结果自己手动加起来看结果

[sbqcel]

即是对的
@TopAllSum 输出也是最后一次的结果；前面的没掉了
这样有什么用？
是不是要在begin...end 里把结果插入一个变量表/临时表里存储起来呢？