分支机构提示被考勤使用过,将要删除的停用,执行语句清除考勤设置数据:
DELETE r FROM WorkTime r WHERE EXISTS ( SELECT 1 FROM SType s WHERE s.TypeId = r.STypeID AND s.[deleted] = 1 )
分支机构提示被考勤使用过,将要删除的停用,执行语句清除考勤设置数据:
DELETE r FROM WorkTime r WHERE EXISTS ( SELECT 1 FROM SType s WHERE s.TypeId = r.STypeID AND s.[deleted] = 1 )