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?