Posted by Scarab on 11/28/05 08:45

Hi,all,
When I use following sql, an error occurs:
insert into #tmprep
EXECUTE proc_stat @start,@end

There is a "select * from #tmp " in stored procedure proc_stat, and the
error message is :

Server: Msg 8164, Level 16, State 1, Procedure proc_stat, Line 42
An INSERT EXEC statement cannot be nested.

What's the metter? Any help is greatly appreciated. Thanks

• Next in forum: Re: An INSERT EXEC statement cannot be nested error.
• Prev in forum: Re: Strange Performance question
• Thread view: An INSERT EXEC statement cannot be nested error.

[Reply to this message]