Någon som ser felet 'Invalid column name 'MatchDate' denna SQL? Finns MatchDate i bo_Division tabellen? Annars måste du nog göra en update med join mot bo_Match.UPDATE i SQL
UPDATE dbo.bo_Division
SET [DivisionSeason] = YEAR(MatchDate)
WHERE DivisionId IN
(SELECT DivisionId FROM bo_Division Where EXISTS (SELECT DivisionId, Min(MatchDate), MatchDate
FROM bo_Division INNER JOIN bo_Match ON bo_Division.DivisionId = bo_Match.MatchDivisionId
GROUP BY DivisionId, MatchDate))Sv: UPDATE i SQL