• PRR.DB (9/25/2013)


    Hi All,

    i am trying to post sp result to temp table then am getting this error, How can i resolve this issue?.

    Msg 8164, Level 16, State 1, Procedure Rep_Accuracy_Achievement_Analysis_Report_PRR, Line 461

    An INSERT EXEC statement cannot be nested.

    Msg 213, Level 16, State 7, Procedure Rep_Accuracy_Achievement_Analysis_Report_PRR, Line 793

    Column name or number of supplied values does not match table definition.

    Ex:

    insert into #Result(ID,Name,Count)

    exec [Rep_Accuracy_Achievement_Analysis_Report]

    please let us see the code?..thanks...hehe