title: Insert values from one table to another having different primary key
body: <p>I have 2 tables. Tab A and Tab B</p>
  
  <p>Tab A</p>
  
  <pre><code>Id       Name
  2        John
  3        Peter
  4        Rachel
  </code></pre>
  
  <p>I need to insert records in table B to get following:</p>
  
  <p>Tab B</p>
  
  <pre><code>PrId    ID       Resident     Date.
  1       2        Yes          7/1/2018
  2       3        Yes          7/1/2018
  3       4        Yes          7/1/2018
  </code></pre>
  
  <p>PrId is the primary key of table B, Id comes from Table A and rest of the values are hard coded.</p>
  
  <p>Please suggest the script to do the same</p>