How can I insert values into a table using a subquery with more than one result

Question

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  thanks for help

User · Answer

If you are inserting one record into your table, you can do

INSERT INTO yourTable 
VALUES(value1, value2)

But since you want to insert more than one record, you can use a SELECT FROM in your SQL statement.

so you will want to do this:

INSERT INTO prices (group, id, price) 
SELECT 7, articleId, 1.50
from article 
WHERE name LIKE 'ABC%'

User · Answer

the sub query looks like   insert into table name  col1 col2       values  select col1 col2     FROM table 2        hope this help

User · Answer

INSERT INTO prices group  id  price  SELECT 7  articleId  1 50 FROM article where name like  ABC

User · Answer

INSERT INTO prices  group  id  price    SELECT 7  articleId  1 50 FROM article WHERE name LIKE  ABC

User · Answer

You want   insert into prices  group  id  price  select      7  articleId  1 50 from article where name like  ABC      where you just hardcode the constant fields

User · Answer

Try this   INSERT INTO prices       group       id      price    SELECT     7      articleId      1 50 FROM     article  WHERE      name LIKE  ABC

[sql] How can I insert values into a table, using a subquery with more than one result?

Examples related to sql

Examples related to insert

Examples related to subquery