How to SELECT FROM stored procedure
You can
- create a table variable to hold theresult set from the stored proc andthen
- insert the output of the stored proc into the table variable, and then
- use the table variable exactly as you would any other table...
... sql ....
Declare @T Table ([column definitions here])Insert @T Exec storedProcname params Select * from @T Where ...
You can use a User-defined function or a view instead of a procedure.
A procedure can return multiple result sets, each with its own schema. It's not suitable for using in a SELECT statement.
You either want a Table-Valued function or insert your EXEC into a temporary table:
INSERT INTO #tab EXEC MyProc