B
buff
Unregistered / Unconfirmed
GUEST, unregistred user!
有以下sql:
DECLARE DN3 cursor for
select LEAVE_QTY,sid,
(select sum(isnull(LEAVE_QTY,0)) from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112))as qty --合计该类商品数量
from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112)
在A机 sql7下执行出错,在B机sql 7 中执行正确,
在A机中只执行:
select LEAVE_QTY,sid,
(select sum(isnull(LEAVE_QTY,0)) from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112))as qty --合计该类商品数量
from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112)
正确,不定义光标就可以,各位高手请提示。
非常之急!
DECLARE DN3 cursor for
select LEAVE_QTY,sid,
(select sum(isnull(LEAVE_QTY,0)) from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112))as qty --合计该类商品数量
from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112)
在A机 sql7下执行出错,在B机sql 7 中执行正确,
在A机中只执行:
select LEAVE_QTY,sid,
(select sum(isnull(LEAVE_QTY,0)) from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112))as qty --合计该类商品数量
from stock_product
where stock_code='01' and isnull(LEAVE_QTY,0)>0 And stock_product_Num='020103007' and convert(varchar(8),expire_date,112)=convert(varchar(8),convert(datetime,'2003-09-30'),112)
正确,不定义光标就可以,各位高手请提示。
非常之急!