selecting rows returned by executing a SP
Is there is any way to select the rows returned by executing a stored procedure. For example I have written a stored procedure like this
create proc ProcPublishers
select * from publishers
tried to execute an statement like this to obtain the rows returned by the stored procedure.
SELECT * FROM EXEC ProcPublishers
But it is returning error. Is there is any other way to select the rows returned by procedure.
Please any one help me.