Abu Dina (9/25/2012)

---

Luis Cazares (9/25/2012)

---

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.

Thanks Luis, your suggestion is valid. I see that Lynne has come back with a potential solution. I will test tomorrow and report back.

Regards.