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?