title: Unique Value for One Insert
body: <p>I have a table called Test and It has two columns called Name and Phone_Number and I am inserting data into the test table from another table called sample. I am doing something like this:</p>
  
  <pre><code>Insert into Test
  select First_Name AS Name,
         Contact_Number AS Phone_Number
   from Sample
  </code></pre>
  
  <p>Now I want to add a third column to the Test table called ID. This ID has to be unique for each Insert.Example:</p>
  
  <p>For Instance if that insert statement inserts 2 records into the test table I want the ID to be 1 and next time when I insert 3 more records then those should have ID as 2 and so on</p>
  
  <p>I thought of creating an Identity but if u insert 3 records at 1 time it will give you 1,2 and 3 but I want unique value for each insert.</p>
  
  <p>Can anyone help me on this?</p>