title: SQL statement to perform incremental updates based upon conditon
body: <p>I am trying to create a sql update statement that will look for a company name sort their accompanying materials alphabetically then update another field in the table in increments of ten after setting a seed value.</p>
  <p>The pseudocode sql I envision is something like this</p>
  <pre><code>@orderincrement = 100
  Update Materials 
  Set Order = @orderincrenment + 10
  where CompanyName = 'ThisCompany'
  order by materials
  </code></pre>
  <p>Current Table Example:
  <a href="https://i.stack.imgur.com/U61cm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/U61cm.png" alt="Current Table" /></a></p>
  <p>What I want it to look like after:
  <a href="https://i.stack.imgur.com/KSYGY.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/KSYGY.png" alt="enter image description here" /></a>
  It has been a while since I have done sql scripting.
  Please provide any suggestions.</p>