-- deletes all results that are 1 year older then the most recent result

DELETE
FROM Results
WHERE ServerTimeApplied < DATEADD(year, -1, (SELECT MAX(ServerTimeApplied) FROM Results))
  AND ResultsID NOT IN (SELECT LastResultsID 
                        FROM ResultsSummary 
                        WHERE LastResultsID IS NOT NULL) 
  AND ResultsID NOT IN (SELECT LastSuccessResultsID 
                        FROM ResultsSummary 
                        WHERE LastSuccessResultsID IS NOT NULL) 
  AND ResultsID NOT IN (SELECT ResultsID FROM DetailedResults)