title: How to update multiple records using data from a record in the same table in T-SQL
body: <p>I need to update records in one table base on data from a certain record.  </p>
  
  <pre><code>ProdFam    ProdID     Color        Form        Price    
  ProdA      ProdA      White        Sheet       $100
  ProdA      ProdA-10   White        Sheet       $10
  ProdA      ProdA-20   White        Sheet       $15
  ProdA      ProdA-25   White        Sheet       $35
  ProdB      ProdB-10   Red          Roll        $24
  ProdB      ProdB-15   Red          Roll        $28
  </code></pre>
  
  <p>So using the example above,  the information for ProdA was updated by a different process and now shows that the color is Off-White and Form is Mul-Sheet.  </p>
  
  <pre><code>ProdFam    ProdID     Color        Form        Price    
  ProdA      ProdA      Off-White    Mul-Sheet   $100
  ProdA      ProdA-10   White        Sheet       $10
  ProdA      ProdA-20   White        Sheet       $15
  ProdA      ProdA-25   White        Sheet       $35
  ProdB      ProdB-10   Red          Roll        $24
  ProdB      ProdB-15   Red          Roll        $28
  </code></pre>
  
  <p>I need to update the rest of the records that have the same ProdFam as ProdA to the new spec.  So the end result should have ProdA all with Color of Off white and Form of Mul-Sheet but their price and ProdID to stay the same.      </p>
  
  <pre><code>ProdFam    ProdID     Color        Form        Price    
  ProdA      ProdA      Off-White    Mul-Sheet   $100
  ProdA      ProdA-10   Off-White    Mul-Sheet   $10
  ProdA      ProdA-20   Off-White    Mul-Sheet   $15
  ProdA      ProdA-25   Off-White    Mul-Sheet   $35
  ProdB      ProdB-10   Red          Roll        $24
  ProdB      ProdB-15   Red          Roll        $28
  </code></pre>
  
  <p>Any help will be greatly appreciated.</p>
  
  <p>Thanks</p>