May 19, 2004 at 7:10 pm
Hi,
sorry if this is the wrong forum but i am a newbie to this.
Currently i have created some stored procedures and when trying to use these in another stored procedure the following errors are reported:
Server: Msg 8164, Level 16, State 1, Procedure usp_Get_All_Station_Flows, Line 14
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Procedure usp_Get_All_Station_Flows, Line 18
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Procedure usp_Get_All_Station_Flows, Line 22
An INSERT EXEC statement cannot be nested.
(0 row(s) affected)
Server: Msg 8164, Level 16, State 1, Procedure usp_Get_Runtime_And_Starts, Line 18
An INSERT EXEC statement cannot be nested.
Server: Msg 8164, Level 16, State 1, Procedure usp_Get_Runtime_And_Starts, Line 25
An INSERT EXEC statement cannot be nested.
Both usp_Get_Runtime_And_Starts and usp_Get_All_Station_Flows work fine by these selves but i am unable to use them
in this other stored procedure.
Can anyone tell me how to get around this? or another solution....
May 22, 2004 at 2:21 am
Read this fine article by Erland Sommarskog, SQL Server MVP:
http://www.sommarskog.se/share_data.html
You will find in this article some other ways share data between stored procedures.
Razvan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply