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,没有问题的