title: T-SQL Update Statment with ORDER BY
body: <p>I am using SQL Server 2005. I would like to update fields like Order BY MatchId orders as below query. But updeted fields not order by MatchId.</p>
  
  <pre><code>DECLARE @counter int
  
  SET @counter = 10008
  
  UPDATE Matches 
  SET @counter = MatchNumberCounter = @counter + 1
  WHERE MatchId IN 
        (SELECT TOP (232) MatchId FROM Matches WHERE LeagueStatueId = 280 AND Week &lt;&gt; 1 
         ORDER BY Week, MatchDate, MatchTime)
  </code></pre>
  
  <p>Thanks already now</p>