I want to Insert into Table , the Results I am getting from View.

Insert into Table1(col1,col2,col3,...........)

values ( 'Hardcodedvalues',(Select col1+col2 from view),(Select col3+col4 from view),'Hardcodedvalues,.......)

above query is giving me error that It's now allowd in subquery.

Any Idea what is the solution for that.

thanks,
TOM

Here is how it should look like:

Insert into Table1(col1,col2,col3,...........)
VALUES SELECT 'Hardcodedvalues',col1+col2, col3+col4, 'Hardcodedvalues' FROM viewname
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


"TOM" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Hi Tom,

You can't have a subquery in this case if it returns more than one row. What
you want you can do in the following way:

Insert into Table1(col1,col2,col3,...........)
SELECT 'Hardcodedvalues', col1+col2 , col3+col4, 'Hardcodedvalues'
FROM view

--
Jacco Schalkwijk
SQL Server MVP


"TOM" <anonymous (AT) discussions (DOT) microsoft.com> wrote