title: How can I insert values into a table, using a subquery with more than one result?
body: <p>I really would appreciate your help.</p>
  
  <p>Probably it's a quite simple problem to solve - but I'm not the one .. ;-)</p>
  
  <p>I have two tables in SQL Server:</p>
  
  <ol>
  <li>article</li>
  <li>prices</li>
  </ol>
  
  <p>Now I want to select a certain set of ids and insert some entries into the prices-table with those ID.</p>
  
  <p>e.g. (wrong and not working SQL)</p>
  
  <pre><code>INSERT INTO prices (group, id, price) 
  VALUES (7, (select articleId from article WHERE name LIKE 'ABC%'), 1.50);
  </code></pre>
  
  <p>SQL Error -> subquery has more than 1 value</p>
  
  <p>thanks for help</p>