dwain.c (4/12/2012)

---

To use my solution you just need to remove the top 2 CTEs (that I took from Sean) and that you say you removed to use his solutions. ...

dwain.c (4/12/2012)

---

It would be interesting to see if it actually runs faster on your test server, as we know that query plans don't tell the whole truth and nothing but...

Thanks for the suggestions.

I have run the code posted by Sean on my test dataset and it returns 2572 rows in 55 seconds.

My cursor function is returning the same dataset...