title: Insert multiple rows with incremental primary key sql
body: <pre><code>INSERT INTO TABLE1 (COLUMN1, PRIMARY_KEY)
     SELECT 
        COLUMN1,
        (SELECT COALESCE(MAX(PRIMARY_KEY), 0) 
          FROM TABLE1) + 1 
     FROM 
        TABLE2
  </code></pre>
  
  <p>error:</p>
  
  <blockquote>
    <p><em>Violation of Primary Key constraint. Cannot insert duplicate key in object.</em></p>
  </blockquote>
  
  <p>How do I make the primary key increment after the first row? </p>
  
  <p>I would like to be able to add a list of items to this table at the same time instead of inserting them RBAR. </p>
  
  <p>Thanks for the help</p>