摘要:
--************--在两个日期范围里所跨越那几周返回如:1,2表是第一周和第二周,declare @aa table (date datetime,weekdays int ) declare @i int set @i=datediff(day,@bdate,@edate) while(@i>=0) begin insert @aa values (dateadd(day,@i,@bdate),datepart(week,dateadd(day,@i,@bdate))) set @i=@i-1 end select weekdays into #week from ... 阅读全文