Post reply

An INSERT EXEC statement cannot be nested

  • October 31, 2013 at 12:06 am

    #279532

    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?

  • October 31, 2013 at 4:06 am

    #1662971

    You really need to post your code for anyone to help with a specific answer.

    MCITP SQL 2005, MCSA SQL 2012

  • October 31, 2013 at 7:44 am

    #1663052

    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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply