declare @StartDate varchar(10) = '12/16/2009' declare @DowsOfWeek = '2,4,6' -- MWF Example declare @TableOfDates table ( WorkDate varchar(10), WorkDateNumber int, SchedStart varchar(10), SchedEnd varchar(10), VarianceFromPlanned int, Booked bit ) -- 2,4,6 is MWF -- 3,5,7 is TTS ------------------------------------------------------------------------------------------------------------------------------------------------------------- WorkDate WorkDateNumber SchedStart SchedEnd VarianceFromPlanned Booked -------------------------------------------------------------------------------------------------------------------------------------------------------------- 12/16/2009 4 121/8/2009 6 12/21/2009 2 12/23/2009 4