title: SQL VB.net insert using select AND values
body: <p>New to using SQL and I am having trouble accomplishing something that I figured would be simple.</p>
  
  <p>I am trying to create and INSERT that will insert the MAX() value from the first column in one table to the first column in another table while the rest of the columns will be filled with parameters.</p>
  
  <p>I have tried switching my code around to see if I just had the syntax wrong but I've had no luck and I'm not even sure what I'm trying to do is possible (at least in a single INSERT).</p>
  
  <p>Here is what I have at the moment:</p>
  
  <pre><code>INSERT INTO [Table2] VALUES(SELECT(Number FROM [Table1] WHERE Max(Number)), @p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10)
  </code></pre>