dwain.c (12/12/2013)
ChrisM@Work (12/12/2013)
-- I might give it a go over lunch.
----------------------------------------------------------------------------------------
I can see it now. Cornish pasty in one hand while the other furiously types in the 1M row test harness.
Mmmm, mmmm! ๐
Good Lord no Dwain, I'd use one of Jeff's fancy shmancy tally tables!!
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden