title: TSQL - Update table from itself
body: <p>Table <strong>Item</strong> (4 columns, simplified for the sake of clarity)</p>
  
  <pre>Record | Item | Price | Zone</pre>
  
  <p><strong>Data</strong></p>
  
  <pre>1      | 100  | 10.00 | A
  2      | 100  | NULL  | B
  3      | 100  | NULL  | C
  4      | 200  | 25.00 | A
  5      | 200  | NULL  | B</pre>
  
  <p>Trying to update the <code>NULL</code>s with the corresponding values from the non-<code>NULL</code>s based on <code>Item</code>. So all Item 100s would read 10.00 and both Item 200s would read 25.00. </p>
  
  <p>I feel like this should be super easy, but can't figure out the self reference. </p>
  
  <p>Thanks</p>