Without manual intervention, one level of INSERT…EXECUTE is the limit
An INSERT EXEC statement cannot be nested.
It is telling you is that you can’t have a proc that does an INSERT-EXEC operation call another proc that also does an INSERT-EXEC operation.
Two basic steps to solve this:
1) Create a #Temp table or @Table var
2) OPENROWSET your stored procedure data into it
INSERT INTO #YOUR_TEMP_TABLE
SELECT * FROM OPENROWSET ('SQLOLEDB','Server=(local);TRUSTED_CONNECTION=YES;','set fmtonly off EXEC [ServerName].dbo.[StoredProcedureName] 1,2,3')
Or check out one of these links: