Post reply

Inserting

  • March 14, 2005 at 4:35 pm

    #163943

    Hi Guys?

    I am dsigning a database in wich every month it must generate interest on the balance of a table.

    my problem is that i don' know how to go about it. i have a table for Members (wich holds the balance availabe) and i have another table to keep the interest(date, interest), every month the db has to calculate the interest (interest = balance * interestrate) and post the interest  into the interest table with the date, i'have tried creatinf procedures, triggers, and nothing. Please Help 

  • March 14, 2005 at 8:58 pm

    #546978

    Schedule a job at the end of month to calculate interest.

  • March 15, 2005 at 7:26 am

    #547046

    Another option is to build a view on your table with one of the fields interest = balance * interestrate

    Kindest Regards,

    Vasc

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply