TSQL: Call a stored procedure from another stored procedure and read the result

You can create a temp table and then use INSERT INTO #MyTable EXEC procedure @param.

There are some other techniques listed here.