title: SQL Server SELECT into existing table
body: <p>I am trying to select some fields from one table and insert them into an existing table from a stored procedure. Here is what I am trying:</p>
  
  <pre><code>SELECT col1, col2
  INTO dbo.TableTwo 
  FROM dbo.TableOne 
  WHERE col3 LIKE @search_key
  </code></pre>
  
  <p>I think <code>SELECT ... INTO ...</code> is for temporary tables which is why I get an error that <code>dbo.TableTwo</code> already exists.</p>
  
  <p>How can I insert multiple rows from <code>dbo.TableOne</code> into <code>dbo.TableTwo</code>?</p>