I have 3 tables - student , settings, subsettings
student table includes studid, name, admissionno, class
settings table includes feesetid, studid , heads
subsettings include - feesubid, feesetid, fromdate, todate,
feeamount, finefromdate1 , finetodate1 , fineamount1 , finefromdate2,
finetodate2, fineamount2
i want to get today's date and check whether today's date falls in
which fine date so that i can add feeamount with fine amount and display
the FeeAmount
How to write procedure for that?
Regards
neethu