Hi Jeff,

I gone through each step to understand this hygienic code. Really leaned new formula's. I know about tally table concept even you advised me to learn about this in my old post. But this tally table function i didn't think about it. Really very useful and greatest code you shared.

thank you so much. Also i learned to avoid recursive CTE and while loop. your precious time on this post was most appreciated.