-- deletes all actions that are 1 year older then the most recent action

DELETE
FROM AdminAuditing
WHERE ActionTime < DATEADD(year, -1, (SELECT MAX(ActionTime) FROM AdminAuditing))