title: Increment column IDs by 1 in insert into statement
body: <p>I have a table I want to insert into based on two other tables. </p>
  
  <p>In the table I'm inserting into, I need to find the Max value and then do +1 every time to basically create new IDs for each of the 2000 values I'm inserting. </p>
  
  <p>I tried something like </p>
  
  <pre><code>MAX(column_name) + 1
  </code></pre>
  
  <p>But it didn't work. I CANNOT make the column an <code>IDENTITY</code> and ideally the increment by one should happen in the <code>INSERT INTO ... SELECT ...</code> statement. </p>
  
  <p>Many Thanks!</p>