Posted my problem with all the details and sample data over here. https://ask.sqlservercentral.com/questions/140089/sql-server-2008-cte-bucket-filling.html