title: Copying rows from target table to source table with conditions
body: <p>Consider below two tables,</p>
  
  <pre><code>Parent Table
  ------------
  Parentid
  1
  2
  3
  4
  5
  6
  
  
  Child Table
  -----------
  
  Id  ParentId  Values
  1     1        val1
  2     2        val2
  3     3        val3
  </code></pre>
  
  <p>Now i want to insert records to child table for parentid 4,5,6 with all values from Parentid 1,2,3. So child table should be like below,</p>
  
  <pre><code>Id    ParentId   Values
   1       1         Val1
   2       2         Val2
   3       3         Val3
   4       4         Val1
   5       5         Val2
   6       6         Val3
  </code></pre>
  
  <p>Please share SQL query for my scenario. I am using SQL server 2008, so let me know any advanced query also. </p>
  
  <p>Note: In my real scenario, I have more number of records. So I don't want to hardcode any values on my insert statement.</p>
  
  <p>Thanks in advance!!</p>