title: Insert into table variable with union
body: <p>I've got a table variable that I'm wanting to insert a union query.  The union query runs fine, but I can't seem to get the insert to work (syntax error)</p>
  
  <pre><code>INSERT INTO @table
  
  (a,
  b,
  c,
  d)
  
  VALUES
  
  (SELECT
         a,
         b,
         c,
         d 
  FROM table1
  
  UNION
  
  SELECT
         a,
         b,
         c,
         d 
  FROM table2)
  </code></pre>
  
  <p>Should this be working?  I can post my real code if there is an issue elsewhere!</p>
  
  <p>I'm getting a syntax error on the first SELECT</p>