999,999 rows in abc to preserve the inline CTE method as is. Enforced the max 12 month count we now know as well as the insert.

results on my machine:

Inline...

Yes, but I would like to point out that your cursor is only selecting 3 rows from a table with only 3 rows. So the overall processing time of...

Please forgive my lack of etiquette. I meant to reference this article by Jeff Moden[/url].

I am humbly submitting this code for review by the gurus here on this forum....

The first article by Jeff Moden in your signature makes the...

your Tally kills the rCTE and hybrid Cursor/Numbers as you can see. On my box:

Inline Tally = 146 milliseconds

rCTE = 2113 milliseconds

Cursor/Numbers = 1183 milliseconds

The Cursor based solution is...

ChrisM@Work (6/18/2013)

---

sagesmith (6/18/2013)

---

Please post the times each approach takes, this is the only basis for a conclusion. As others have already mentioned, in many scenarios the cursor far outperforms...

Nice!

Please post the times each approach takes, this is the only basis for a conclusion. As others have already mentioned, in many scenarios the cursor far outperforms the recursive...