title: How to copy records to another table based on a condition?
body: <p>I have a table1 contains 4 columns </p>
  
  <pre><code>AssociateId, chk1, chk2, chk3
  </code></pre>
  
  <p>and another table(table2) contains same 4 columns.</p>
  
  <pre><code>chk1, chk2, chk3 
  </code></pre>
  
  <ol>
  <li>Columns will have the values 'yes/no/null'</li>
  <li>If table1 contains 3 records and 2 records contains the value 'yes' for all chk1,chk2,chk3 columns, then both records have to be inserted into table2</li>
  <li>Furthermore, these 2 records should be removed from table 1.</li>
  </ol>
  
  <p>How is it possible using SQL Server 2008?</p>