title: t-sql: update in specific order determined by 'in' expression
body: <p>Suppose:</p>
  
  <pre><code>declare @counter int
  set @counter = 0
  
  update MyTable
  set @counter = MyField = @counter + 1
  where Some_ID in (select ID from SomeTable)
  </code></pre>
  
  <p>What I want is that update happened in same order as <code>select ID from SomeTable</code> IDs are returned. Is there a nice way to do this?</p>