8164 - An INSERT EXEC statement cannot be nested.

[Bob]

Can anyone suggest a way around this?

The error message appears when my sproc_1 which contains

INSERT table_name_1 EXEC sproc_2

calls to sproc_2 which contains the TSQL line

INSERT table_name_2 EXEC sproc_3

Thanks!

[Dale Shaw]

CREATE Table #temp (...)

INSERT @#temp EXEC sproc_3

INSERT table_name_1 SELECT * FROM #temp

DROP TABLE #Temp

?

Dale