Stored Procedure for calculating total no of leave

Question

Need to write stored procedure & need to create a event scheduler in mysql for total leaves for an employee & balance leaves..

Nilesh Patil · Answer

Hi Refer this links http://www.aspforums.net/Threads/152673/Calculate-number-of-leaves-taken-by-Employee-in-a-month-in-SQL-Server/ https://www.codeproject.com/Questions/772355/Stored-Procedure-calculating-employee-earnings

Nagendra Babu · Answer

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...:)