I have a long stored procedure that get me a SELECT of many
fields in many tables, passing one parameter of type INT.
Is it possible execute a SELECT statement on this stored procedure
with a WHERE clause?
For example, something like this:
EXEC myStored 101
WHERE Field1 = 'test';
Thank you in advance.