Stored Procedure for calculating total no of leave

Hi Nilesh Patil,

 

Thank You,

 

Actually my req is , a employee as total 20 leaves per year in that 8 leaves left  , that leaves need to carryforward to next year ....

 

Need to write stored procedure and need to call that procedure in scheduler...:)