Delete ev FROM Evaluation AS ev
Inner Join Employee AS e ON ev.EmployeeId = e.EmployeeId
WHERE
e.OfficeId IN ( SELECT OfficeId FROM Office WHERE ThirdLevel = 2790 AND IsActive = 1 )
AND ev.Year = 2019
AND ev.EvaluationPeriodShort = 'D'
Inner Join Employee AS e ON ev.EmployeeId = e.EmployeeId
WHERE
e.OfficeId IN ( SELECT OfficeId FROM Office WHERE ThirdLevel = 2790 AND IsActive = 1 )
AND ev.Year = 2019
AND ev.EvaluationPeriodShort = 'D'
No comments:
Post a Comment