I know it could be a bad solution, and maybe you had tought about it.

But since the rCTE is not scaling well (and it sure won't) why don't you use your original solution in a while loop for @@rowcount > 0?

I'm not sure which will scale better, but it's still an option.