title: SQL Server copy contents based on ID
body: <p>In my DB I have 7 rows for 3 different entities, I want to mirror the contents of one entity to the other two based on an ID value.  I do not know if an update statement is appropriate. </p>
  
  <pre><code>CoId  DocumentType  StatusId  StatusDescription  Default  Text  Progression  Environment  RequiredOnAssign  TS  DocumentFilterGroup
  </code></pre>
  
  <p>These are my column headers, <code>CoId</code> can have one of three values, 1, 2, or 3. I wish to copy the contents of 1 into 2 and 3 based on status ID. I have having trouble articulating further than this.</p>