Jeff, After reading up on CTE and understanding what you provided, that's exactly what I needed. Old data will never change therefore I won't use the where clause but nice...
First of all, thank you for the assistance. After running the code and re-reading my post. I realized in my first post, the numbers I was using happened to be...