born2achieve (10/19/2013)
wow, thanks a lot lynn and SSC.Hi lynn,
I would like to understand your concept. Is it possible to give me brief explanation about your logic would be great.
Go down to the fourth link in my signature block regarding Tally tables. Read that article. It will tell you all you want to know about tally tables. What I did in my code is create a dynamic tally table as a CTE.