Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Calculate pmt in t-sql (like excel)

    complement of function return payment of being or end

    select @PV*Power((@apr+1),@nper)*@apr/(Power((@apr+1),@nper)-1); payment end

    select (@pv*Power((@apr+1),@nper)*@apr/(Power((@apr+1),@nper)-1))/(@apr+1); bein of payment

Viewing post 1 (of 1 total)