删除考勤重复刷卡记录？

Question

1. ```FOR DELETE,Update
   AS

2. delete from onoffdutydata where onoffdutyid in (
   select a.onoffdutyid From onoffdutd in (
   select a.onoffdutyid From onoffdutydata a inner join employeemsg b on a.employeeid=b.employeeid
   and a.checkdate<b.ondutytime)

3. delete from employeesalary where salaryid in (
   select a.salaryid From employeesalary a inner join employeemsg b on a.employeeid=b.employeeid
   and a.Yearmonth>convert(nvarchar(7),outdutytime,21))

4. delete from employeesalary where salaryid in (
   select a.salaryid From employeesalary a inner join employeemsg b on a.employeeid=b.employeeid
   and a.Yearmonth<convert(nvarchar(7),ondutytime,21))

5. delete from originalcheckdata where originaldataid in (select a.originaldataid from originalcheckdata a inner join originalcheckdata b
   on a.employeeid=b.employeeid and a.occurtime=b.occurtime and a.originaldataid>b.originaldataid)

GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

![图片说明](https://img-ask.csdn.net/upload/201912/20/1576841900_935726.png)

Answer 1

根据提供的SQL语句，这个问题实际上是想删除考勤系统记录中的重复刷卡记录以及相应的薪资记录。具体来说，第2个SQL语句会删除早于员工上岗时间的考勤记录；第3个SQL语句会删除离职时间之后的薪资记录；第4个SQL语句会删除入职时间之前的薪资记录；第5个SQL语句会删除具有相同员工ID和出现时间的记录中，ID更大的记录。另外，整个SQL代码块使用的是T-SQL语言，并开启了两个参数设置（SET QUOTED_IDENTIFIER OFF和SET ANSI_NULLS ON）。