Debugged a stored procedure

Today I debugged a stored procedure in our SQL server, it is used to apply leave for multiple employees. Our OA system lacked the function used by the HR colleague to set leave for all employees from different departments at the same time.

Every Chinese New Year holiday, the HR colleague would ask me to set five specific dates as paid leave for employees with more than one year of service, and unpaid leave for others. I then wrote a few lines of SQL code to implement the requirement directly on the attendance result of our OA system.

I have created the stored procedure in our SQL server to implement this function, so it will be helpful for me. In addition, I will  integrate this function into our OA system, and then the HR colleague won't ask me again in the future.