declare @LastWeekDate DateTime
declare @LastWeekDay2 DateTime
declare @LastWeekDay6 DateTime
declare @DayNumber int
set @LastWeekDate = getDate() -7
select @LastWeekDate
select @DayNumber = DatePart(dw, @LastWeekDate)
set @LastWeekDay2 = @LastWeekDate - (@DayNumber-2)
set @LastWeekDay6 = @LastWeekDate - (@DayNumber-6)
select @LastWeekDate, @LastWeekDay2, @LastWeekDay6