OPMS/清除簽到資料.sql

--Step1�G�M������
Declare @SaveYearCheck as INT;
Set @SaveYearCheck = 2;   --�]�w�O�d���~��

--�ˬd�R������
Select * From OTB_HR_CheckAttendance Where ModifyDate <= DATEADD(year,-@SaveYearCheck,Getdate()) And MemberID IN (
Select MemberID From OTB_SYS_Members Where Effective ='N'
)

--�i�����ƧR��
/*
Declare @SaveYear as INT;
Set @SaveYear = 2;   --�]�w�O�d���~��

--�ˬd�R������
Delete OTB_HR_CheckAttendance Where ModifyDate <= DATEADD(year,-@SaveYear,Getdate()) And MemberID IN (
Select MemberID From OTB_SYS_Members Where Effective ='N'
)
*/