I have now solved my problem, but don't understand why.

I constructed a very simple stored_proc along the lines of :

sp_OUTER

AS

...

SET @Loop = 99

WHILE @Loop > 1

..BEGIN

....EXEC sp_INNER @Loop

....SET @Loop =...