Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

An INSERT EXEC statement cannot be nested Expand / Collapse
Author
Message
Posted Thursday, October 31, 2013 12:06 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Monday, September 15, 2014 7:07 AM
Points: 697, Visits: 928
Hi All,

While executing sp, i am getting this error,

Msg 8164, Level 16, State 1, Procedure AxSp_AccAchievement_Report, Line 197
An INSERT EXEC statement cannot be nested.


I identified this issue, i am posting procedure result into hash table in Multiple level.

But for this issue any other ways to resolve this?
Post #1510028
Posted Thursday, October 31, 2013 4:06 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, August 11, 2014 6:37 AM
Points: 299, Visits: 561
You really need to post your code for anyone to help with a specific answer.

MCITP SQL 2005, MCSA SQL 2012
Post #1510090
Posted Thursday, October 31, 2013 7:44 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:57 AM
Points: 986, Visits: 1,327
The simple answer to this problem is you are already performing an INSERT EXEC which is in the stored procedure you are calling, just as the error indicates.

Kurt


Kurt W. Zimmerman
SR DBA
Lefrak Organization
New York, NY

http://www.linkedin.com/in/kurtwzimmerman
Post #1510179
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse