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