title: TSQL Update using MAX()
body: <p>I'm trying to update a column to a max value, but only when grouped by the appropriate identifier.</p>
  
  <p><a href="http://sqlfiddle.com/#!3/231ac/26" rel="nofollow">SQL Fiddle</a> for what I'm trying to do with trial &amp; failed code :(.</p>
  
  <p><a href="http://sqlfiddle.com/#!3/cd359/1" rel="nofollow">SQL Fiddle</a> for what I want it to look like after update.</p>
  
  <p>Any assistance you could lend me will be greatly appreciated.  As I understand it max() just takes the largest number of the column, so how do I sort in an update statement without wrecking it?</p>