I have a stored procedure that returns rows:
CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END
My actual procedure is a little more complicated, which is why a sproc is necessary.
Is it possible to select the output by calling this procedure?
SELECT * FROM (EXEC MyProc) AS TEMP
I need to use
SELECT TOP X,
ROW_NUMBER, and an additional
WHERE clause to page my data, and I don't really want to pass these values as parameters.