INSERT Query with Sub-Query?

[jchastai]

Is it possible to have a SELECT query insided of an INSERT Query?

i.e. -
INSERT INTO Table1 (ID, Type, etc ...)
VALUES (1, SELECT Type FROM Table2 WHERE ...., etc ...)

I thought it sounded reasonable enough, but I am getting errors. Just an attempt to lighten the number of hits on the database.

Thanks for your help.

 

[cmmrfrds]

Here is the syntax from Sql server help.

Use a SELECT subquery to specify the data values for one or more rows.

INSERT INTO MyTable (PriKey, Description)
SELECT ForeignKey, Description
FROM SomeView