SELECT statement on a stored procedure

Ciupaz · November 22, 2019, 12:54pm

Hello,
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:

SELECT *
FROM
EXEC myStored 101
WHERE Field1 = 'test';

Thank you in advance.

Luis

harishgg1 · November 22, 2019, 12:56pm

hi hope this link helps !!!

Ciupaz · November 22, 2019, 1:01pm

So, using a temporary table, like this:

INSERT INTO #CompleteExec
EXEC myStored 101;

SELECT *
FROM #CompleteExec
WHERE Field1 = 'test';

Thank you for the advice Harish.

Luis