title: Insert into from select query error in SQL Server
body: <p>I am using the below query to insert data from one table to another:</p>
  
  <pre><code>DECLARE @MATNO NVARCHAR(10), @GLOBALREV INT, @LOCALREP INT
  
  SET @MATNO = '7AGME'
  SET @GLOBALREV = 11
  SET @LOCALREP = 1
  
  INSERT INTO CIGARETTE_HEADER 
  VALUES 
      (SELECT * 
       FROM CIGARETTE_HEADER_BK1 
       WHERE MATERIAL_NUMBER = @MATNO 
         AND GLOBAL_REVISION = @GLOBALREV 
         AND LOCAL_REVISION = @LOCALREP)
  </code></pre>
  
  <p>The column in both the tables are same, but I am getting the following error:</p>
  
  <blockquote>
    <p>Msg 156, Level 15, State 1, Line 7<br>
    Incorrect syntax near the keyword 'SELECT'.</p>
    
    <p>Msg 102, Level 15, State 1, Line 7<br>
    Incorrect syntax near ')'.</p>
  </blockquote>
  
  <p>Can you please let me know the mistake here?</p>