Update sql table column with values from other table using spatial method contains to find the link between tables

  UPDATE a 
  set a.Score = _TARGET.Score
  FROM McD_ROI_Hex_All_Afternoon a
  JOIN [SandBox].dbo.[McD_ROI_Hex_Timebuckets] AS _TARGET
  ON a.SP_GEOMETRY.STContains(_TARGET.SP_GEOMETRY) = 1
  AND a.Sum_Avg_Users = _TARGET.Sum_Avg_Users;