phoenix_ (5/29/2013)

---

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 = DATEADD(ww, DATEDIFF(ww,0,@StartDate), 0)

set @DateCalc = @StartDate

WHILE (@WeekStartDate <= @EndDate )

begin

select case when @StartDate > @WeekStartDate then DatePart(ww,@StartDate) else DatePart(ww,@WeekStartDate) end as WeekNum, @WeekStartDate as WeekStartDate, DATEADD(dd, 6, @WeekStartDate) as EndDate;

set @WeekStartDate = DATEADD(dd, 7, @WeekStartDate)

set @StartDate = @WeekStartDate

END

Is it possible somehow to convert it to 'one' select statement so I will have only one result?