It's a little vauge and not my forte but I'll give it a shot.

Is this all being run in one sql statement or is it run SP_1 then SP_2

You could...