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....