Teee (6/13/2013)@Kingston Dhasian, Thank you so much for the script that's returning the dates it works perfectly.

I am glad it worked for you and I hope you understand what the code does and howI would also advise you to go through the articles on Tally articles on this site which help you solve a lot of similar problemsYou can start with the link given belowhttp://www.sqlservercentral.com/articles/T-SQL/62867/