Build a test table is very useful, huh, in fact, I can't keep SQL Server support while loop, I am always used to using for loops, the result is always found in the help.
Declare @i int set @ i = 1WHILE @i <30begin insert @ i = @ i 1END
-------------------------------------------------- -------------------------------------------------- ---------
Written SQL generated a date table, huh, huh, for your own tip class: P
Declare @lesson int set @lesson = 1
Declare @WeekIndex Intset @WeekIndex = 1
Declare @date dateadd @date = dateadd (day, datediff (day, 0, getdate ()), 0) - This can remove hate hours
while @lesson <97begin set @weekIndex = @weekIndex 1 if @weekIndex = 7 begin insert into NewConcept2 (Lesson, FinishDate) values (0, @ Date) set @weekIndex = 0 end else begin insert into NewConcept2 (Lesson, FinishDate) VALUES (@lesson, @date) set @lesson = @ lying = dateadd (day, 1, @date)
end
