[/src]
    Begin
 --Открываем курсор по оплатам
 
select @pricesum=Полная стоимость товара
declare pays cursor for select paysum from #pays
open pays
while  1 = 1 
begin
fetch pays into @Paysum
if @@fetch_status<> 0  break
        //Выбрасываем то,что уже оплачено    
        select @Rest= 0 
        select @value = @PriceSum 
            Update #TempRes 
            set @Value=@Value-cost*Quantity,
                @Quantity=Quantity = case 
                                        when (@Value> 0 ) then Quantity  
                                        else 
                                            case 
                                                when  (@value+cost*Quantity> 0 )
                                                then  Quantity-floor(round((@Value+cost*Quantity)/cost, 2 , 0 ))
                                                else  Quantity  
                                            end
                                    end,
                need = case when (@Value> 0 ) and  @Quantity=Quantity
                            then  2  
                            else  0  
                    end,                              
        
                    @Rest= case when @value+cost*Quantity> 0 
                    then @value+cost*Quantity-(Quantity-@Quantity)*cost
                    else @Rest end
                    
            From #TempRes           
        End                            

     --Оплачиваем сколько можем
 
        select @value= @PaySum

        update  #TempRes 
        set     @Value = @Value-cost*Quantity,
                @Quantity = Quantity = 
                            
                            case when (@Value>= 0 ) 
                                then Quantity  
                                    else  floor(round((@Value+cost*Quantity)/cost, 2 , 0 ))
                            end,
                            
                need = 
                
                case when (@Quantity> 0 ) 
                    then  1  
                        else  0  
                end                           
                
        from    #TempRes     
        where   need<> 2 


 --результат этой оплаты 
 
select * from #TempRes where need= 1 

select @PriceSum=@PriceSum-@PaySum
update #TempRes set need= 0 
end
[src]