Automatic update (periodic)

Hi,

 This may be another horrible idea.

• Is There any way to auto update columns of database table.

  ---

Suppose I'm managing a database for school children. There is a table to hold all student's continuous assesments marks.

(Student_id, date, assesment_no, marks)

At the end of each month total for that month and full total(up to date)
should be calculated.
I have another table for this.

(Student_id, total_january, total_february, ....... , Total)

At the end of month respective total column to that month and last column (total)
should be updated.

I can do this by manually executing a procedure at the end of each month.

But is there any automatic way to do this.???? I can store procudure. It should Execute at the proper time by looking at system clock.

I hope you understood my problem.
Please let me know if it is not clear (Wrong grammer etc..)

Please Give me some Idea to solve this problem. Received on Wed Apr 12 2006 - 11:52:31 CDT