Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    1

    Unanswered: Rate() and PMT()

    If you are familiar with Crystal reports or Visual basic, you may be familiar with the Rate and Pmt functions.

    I need to duplicate them in SQL sever 7.

    Anybody have code for this already? I hate re-inventing the wheel.

    More (Unnecesary) details:
    I have a client who has handed me the formula that I need to use for calculating Interest rates. Unfortunatly, the formula was written in Crystal reports, so now I need to pick it apart and do the work that CR does automaticly. Any help?

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check this site, it should contain what you're looking for:

    http://www.wheatworks.com/formula.htm
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •