There are cases when SQL developers want to filter the results of Procedures Output. This requires inserting the results of the procedure in the table. Here is how it can be done
Filter Procedure Output
In the above example the temp table is created with the same columns as that of the procedure output, the Procedure is executed and then stored in the table #temp. The table is later filtered on the users criteria.
Hi, nice post. I have been pondering this issue,so thanks for posting. I’ll definitely be subscribing to your blog.