select office_name,sales_incharge_name,article_no,
article_name,process_location,sale_yearmonth,
customer_cd,customer_info,
contract_section,customer_type, sale_amount_notax,
purchase_amount_notax,
income_amount_notax,
request_amount,income_amount ,
F_GetRemainAmount('200609','200609','200609',request_amount,income_amount,office_name,'1') one,
F_GetRemainAmount('200609','200609','200609',request_amount,income_amount,office_name,'0') two,
F_GetRemainAmount('200609','200608','200608',request_amount,income_amount,office_name,'0') three,
F_GetRemainAmount('200609','200607','200607',request_amount,income_amount,office_name,'0') four,
F_GetRemainAmount('200609','200604','200606',request_amount,income_amount,office_name,'0') five,
F_GetRemainAmount('200609','200510','200603',request_amount,income_amount,office_name,'0') six,
F_GetRemainAmount('200609','200410','200509',request_amount,income_amount,office_name,'0') seven,
F_GetRemainAmount('200609','198008','200409',request_amount,income_amount,office_name,'0') eight,
from v_testtest
问题:
前一百条记录,ONE,TWO,THREE,FOUR,SIX,SEVEN,EIGHT 8列值返回都是正确的
100条记录后返回的都是0了,其它列值都是正确的。
F_GetRemainAmount 是一个函数,,里面调用了另个一个函数。 如果从V_TESTTEST一条条的执行这个SQL,没有问题的
article_name,process_location,sale_yearmonth,
customer_cd,customer_info,
contract_section,customer_type, sale_amount_notax,
purchase_amount_notax,
income_amount_notax,
request_amount,income_amount ,
F_GetRemainAmount('200609','200609','200609',request_amount,income_amount,office_name,'1') one,
F_GetRemainAmount('200609','200609','200609',request_amount,income_amount,office_name,'0') two,
F_GetRemainAmount('200609','200608','200608',request_amount,income_amount,office_name,'0') three,
F_GetRemainAmount('200609','200607','200607',request_amount,income_amount,office_name,'0') four,
F_GetRemainAmount('200609','200604','200606',request_amount,income_amount,office_name,'0') five,
F_GetRemainAmount('200609','200510','200603',request_amount,income_amount,office_name,'0') six,
F_GetRemainAmount('200609','200410','200509',request_amount,income_amount,office_name,'0') seven,
F_GetRemainAmount('200609','198008','200409',request_amount,income_amount,office_name,'0') eight,
from v_testtest
问题:
前一百条记录,ONE,TWO,THREE,FOUR,SIX,SEVEN,EIGHT 8列值返回都是正确的
100条记录后返回的都是0了,其它列值都是正确的。
F_GetRemainAmount 是一个函数,,里面调用了另个一个函数。 如果从V_TESTTEST一条条的执行这个SQL,没有问题的
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货