title: Insert Into Existing Table with Complexities
body: <p>I am trying to copy some info from a table that has been set up properly into another table that is being configured. The table in question stores settings for users as recognised by their Active Directory user (for the program that is accessing the database).</p>
  
  <p>I can't just copy the table across because there are different users in each table with different settings. I am only concerned with a specific criteria.</p>
  
  <p>The table is set up with the following columns:
  SeqNum
  User
  Data1
  Data2
  Data3
  Data4</p>
  
  <p>SeqNum and User will be different between tables and the rows will need to be new, not modifying existing. What I want to do is insert new rows with the next available SeqNum and a SPECIFIED user (that I can specify) and then copy the columns Data1-Data4 into their respective columns. The number of rows to be inserted will vary. Does anyone have a suggestion on the best way to achieve this? I don't think I can do a simple insert into becuase that won't account for the variable in SeqNum and User.</p>
  
  <p>To make this a little clearer, I have attached an image showing an example of Table 1 and Table 2 with the addition of the three new lines in Table 2.</p>
  
  <p>Hopefully this sort of makes sense. There will be hundreds of lines and dozens of users that this will need to be done to.</p>
  
  <p>T.I.A.</p>
  
  <p><a href="https://i.stack.imgur.com/t0VtH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/t0VtH.png" alt="enter image description here"></a></p>
  
  <p><a href="https://i.stack.imgur.com/t0VtH.png" rel="nofollow noreferrer">http://i.stack.imgur.com/t0VtH.png</a></p>