How to join the result set of two stored procedures

Question

I have a stored procedure which contains more that 25 queries and pass the line limit of MySQL stored procedure causing memory exhausted error.

So what I want is to divide it into two stored procedures and create a third stored procedure to union the two procedures. Can anyone help me with this?

What have you done so far?? Show us something to help you out.. — Sujeet Sinha, Jul 12 '16 at 14:18
this is exactly what i want to do but in mysql http://stackoverflow.com/questions/5292069/union-the-results-of-multiple-stored-procedures — Robel Alemu, Jul 12 '16 at 14:20
maybe [**THIS**](http://stackoverflow.com/questions/1637288/can-a-stored-procedure-function-return-a-table) help, but looks like isnt possible. — Juan Carlos Oropeza, Jul 12 '16 at 14:21
I answered similar [here](http://stackoverflow.com/a/37635488) — Drew, Jul 12 '16 at 14:23
okay at least is there a way i can put all my queries in on store procedure . i mean if there is a way to bypass the memory exhausted error ? — Robel Alemu, Jul 12 '16 at 14:24
Maybe your query needs a facelift so it is not exhausting memory. We lack anything to work with here. — Drew, Jul 12 '16 at 14:25
you probably have a stored procedure that needs a lot of improving!! — e4c5, Jul 13 '16 at 03:26

score -1 · Answer 1 · answered Jul 12 '16 at 14:25

Just push the results of both sp calls into a temp table:

/*Create a table with the same columns that the sp returns*/
CREATE TABLE #tempblahblah(blahblahblah NVARCHAR(50))

INSERT #tempblahblah ( blahblahblah )
 EXEC MyStored 0

INSERT #tempblahblah ( blahblahblah )
 EXEC MyStored 1

SELECT * FROM #tempblahblah

How to join the result set of two stored procedures

1 Answers1