How to get a one-year timetable

haigerrual

Create such a table
The contents of the table are the day before yesterday's date, today's date, tomorrow's date, today's week (such as Monday, Tuesday), today's week number (week function),
The key is to have one year of data after the establishment of this table

gaoqingfeng

Is it like this?

create table tb(yest datetime,today datetime,tomorrow datetime,weekname varchar(10),weeks int)
declare @day int,@dt datetime
set @day=0
set @dt='2016-01-02'
while @day<365
begin
insert tb select dateadd(day,@day,@dt),dateadd(day,@day+1,@dt),dateadd(day,@day+2,@dt),datename(dw,@dt+@day), datediff(week,@dt,dateadd(day,@day,@dt))+1
set @day=@day+1
end

select * from tb

drop table tb

haigerrual

yes, very good!
Thank you upstairs
Unpost at night