SQL Server Insert based of additional query

Question

Using SQL server is it possible to to a mass insert based on a sub query, Essentially I'm trying to do this.

Insert into ProductExtra (ProductID,ExtraID) 
VALUES 
(Select ProductID From ProductSKU 
JOIN Product on ProductSKU.ProductID = Product.ID
Where ItemType = 'fire grate' ), 10739

marc_s · Accepted Answer · 2012-11-02 11:28:20Z

4

Yes - but then you must not use the VALUES keyword, but this syntax (just a SELECT, with columns and fixed values defined in its list of selected columns) instead:

INSERT INTO ProductExtra (ProductID, ExtraID) 
   SELECT ProductID, 10739
   FROM ProductSKU 
   JOIN Product ON ProductSKU.ProductID = Product.ID
   WHERE ItemType = 'fire grate'

answered Nov 2, 2012 at 11:28

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

John Woo · Accepted Answer · 2012-11-02 11:28:52Z

1

use INSERT INTO...SELECT statement.

INSERT INTO ProductExtra (ProductID, ExtraID) 
Select   ProductID, 10739 ExtraID
From     ProductSKU 
         INNER JOIN Product 
              ON ProductSKU.ProductID = Product.ID
Where ItemType = 'fire grate'

answered Nov 2, 2012 at 11:28

John Woo

265k70 gold badges509 silver badges500 bronze badges

Comments

Thangamani Palanisamy · Accepted Answer · 2012-11-02 11:29:17Z

1

You can try like this

INSERT INTO ProductExtra (ProductID,ExtraID) 
Select ProductID,10739 From ProductSKU 
JOIN Product on ProductSKU.ProductID = Product.ID
Where ItemType = 'fire grate'

answered Nov 2, 2012 at 11:29

Thangamani Palanisamy

5,3204 gold badges36 silver badges39 bronze badges

Collectives™ on Stack Overflow

SQL Server Insert based of additional query

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related