VD (9/3/2015)
Sweet! I tried that approach with the order by testdate ACS and of course the grouping was wrong. I will figure out the regrouping with dense_rank()!thanks so much!
You're welcome! Post back if you get stuck.
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