Select * from tb1 where SDate >
case DATEPART(DW,FDate)
when 1 then dateadd(day,4,FDate)
when 2 then dateadd(day,3,FDate)
when 3 then dateadd(day,3,FDate)
when 4 then dateadd(day,5,FDate)
when 5 then dateadd(day,5,FDate)
when 6 then dateadd(day,5,FDate)
when 7 then dateadd(day,4,FDate)
end
/*注意每周起始日的设置*/