如何在使用SQL Job的过程中每月针对雇员添加叶子

问题描述

大家好，

我创建了一个表tblEmployee(员工详细信息)和tblLeaveDetail(EmpID，LeaveTaken，LeaveRemain).
我需要做一份工作，每个月应在剩下的叶子上增加两天半的时间.如果某人在15日之后的那个月加入，那么只会增加1个请假.

请帮忙.

谢谢
sanjeev

Hello All,

I have created a table tblEmployee(employee detail) and tblLeaveDetail(EmpID,LeaveTaken,LeaveRemain).
I need to make a job by which every month there should be addition of two and half day in there remaining leaves. if a person is joining in that month after 15th then only 1 leave will get added.

please help.

thanks
sanjeev

推荐答案

这篇关于如何在使用SQL Job的过程中每月针对雇员添加叶子的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！