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