t-sql stored procedure add where clause outside of SP

Question

I have a stored procedure that I cannot modify, but I need to add a where clause to filter it even more. What would be the best way to do this without inserting data from stored procedure to a temptable then doing a where on that temptable. Is there another way?

check out this question http://stackoverflow.com/questions/1492411/sql-server-select-from-stored-procedure — th1rdey3, Oct 17 '13 at 17:34

score 0 · Answer 1 · answered Oct 18 '13 at 08:11

0

The store procedure is executable but filtering happens inside the select statement so you should bring the result in a table to select it. There is no way except temp tables. Table valued Udf also has table like temp tables.

answered Oct 18 '13 at 08:11

Amir Keshavarz

3,050
1
19
26

t-sql stored procedure add where clause outside of SP

1 Answers1