DECLARE @StartDate DATETIME, @EndDate DATETIME SET @StartDate = '1-6-2007' -- you might want to verify this is a saturday date SET @EndDate = '7-7-2007' ;WITH DateCTE(WeekEndingCTE) AS -- anchor query (SELECT @StartDate AS WeekEnding UNION ALL -- recursive query SELECT WeekEnding + 7 AS WeekEnding FROM WeekEndingCTE WHERE WeekEnding < @EndDate ) -- Now do something wtih WeekEndingCTEThat will give you a list of every Saturday date in that date range.