|
Execute the following
script in Query Editor:
USE AdventureWorks
GO
CREATE TABLE HumanResources.PayCalendar( ID int IDENTITY not NULL,
WeekStart char(10) null, WeekEnd char(10) null)
GO
INSERT HumanResources.PayCalendar VALUES('2005/06/19',
'2005/06/25')
WHILE (SELECT MAX(WeekStart) FROM HumanResources.PayCalendar)
<= '2021/01/07'
BEGIN
INSERT HumanResources.PayCalendar
SELECT CONVERT(char, DATEADD(day, 7, MAX(WeekStart)), 111),
CONVERT(char, DATEADD(day, 7, MAX(WeekEnd)), 111)
FROM HumanResources.PayCalendar
END
|