You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
19 lines
552 B
19 lines
552 B
--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'
|
|
)
|
|
*/
|