--Step1：清除簽到資料
Declare @SaveYearCheck as INT;
Set @SaveYearCheck = 2;   --設定保留的年份

--檢查刪除資料
Select * From OTB_HR_CheckAttendance Where ModifyDate <= DATEADD(year,-@SaveYearCheck,Getdate()) And MemberID IN (
Select MemberID From OTB_SYS_Members Where Effective ='N'
)

--進行資料刪除
/*
Declare @SaveYear as INT;
Set @SaveYear = 2;   --設定保留的年份

--檢查刪除資料
Delete OTB_HR_CheckAttendance Where ModifyDate <= DATEADD(year,-@SaveYear,Getdate()) And MemberID IN (
Select MemberID From OTB_SYS_Members Where Effective ='N'
)
*/