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