Unanswered: An INSERT EXEC statement cannot be nested
I have a Stored Procedure which I need to use the output of in another Stored Procedure but I am not able to write the output of SP1 into a Temp table as I get the following error:
An INSERT EXEC statement cannot be nested
I cannot simply reqrite SP1 as it is locked and I am not able to see the contents of it.
Can anyone offer any assistance? I have tried OPENROWSSET but clearly I am doing something wrong as I cant get that to work either. I need to pass 4 parameters to SP1 and somewhere some how I am doing something wrong.