After searching some more, I found that syntax. It worked, and now I am back coding and not searching.

I wonder why the other syntax is plastered all over the internet in referance to SQL 2008 if it is not valid? Sometimes I get frustrated when I encounter answers on the web that either unrelatered or flat out wrong.

Thank for the reply.

>It's invalid syntax. You have to create a [temp] table with columns that match SP recordset first and then
>

>INSERT INTO <table name> EXEC [mySP] 'para1'
>

>
>
>>I have several individual stored procedures that are related. I am looking to select from them all into a single select statement result. The syntax I have noticed all over the web suggests
>>
>>

>>SELECT * FROM EXEC [mySP] 'para1'
>>

>>
>>But, SQL Server tells me that it is a syntax error to use the EXEC in the data source in the above statement. Is there some setting I must configure before this type of syntax is accepted?