title: Insert to sql server table from field from another table and varchar field
body: <p>I need to populate reqopt table which have two varchar fields (valeur, categorie), the first shoud be field from another table (mytable) and another should be a simple varchar ('prop').
  I've tried this</p>
  
  <pre><code>INSERT INTO reqopt(valeur, categorie) (select distinct name from mytable , 'prop') 
  </code></pre>
  
  <p>I got this error <code>Incorrect syntax near 'prop'.</code></p>