I am not doing calculations with such precision. I was just going to display the data with such accuracy. i.e. I have 2013-09-15 which is the end of the week...

To be honest with you I don't like dynamic sql because of quotation marks '' which are making whole code harder to read 🙂

So Instead of this I developed something...

Kingston Dhasian (5/29/2013)

Yes. It is possible to convert it to single SELECT...

In the meantime I created something like this...

declare @StartDate date

set @StartDate = '2013-01-03'

declare @EndDate date

set @EndDate = '2013-02-21'

declare @DateCalc date

declare @WeekStartDate date

set @WeekStartDate...

It works for me. Thank you very much.