IF EXISTS(SELECT *
FROM sysobjects
WHERE name = 'Weaver_System_Date')
DROP TABLE Weaver_System_Date
GO
CREATE TABLE Weaver_System_Date(
id INT IDENTITY(1,1) PRIMARY KEY,
systemdate DATE
)
GO
DECLARE @BEGIN_DATE DATETIME
SELECT @BEGIN_DATE = '2000-01-01'
WHILE @BEGIN_DATE <='2100-12-31'
BEGIN
INSERT INTO Weaver_System_Date (systemdate) VALUES (@BEGIN_DATE)
SELECT @BEGIN_DATE = DATEADD(DD, 1, @BEGIN_DATE)
END
GO
FROM sysobjects
WHERE name = 'Weaver_System_Date')
DROP TABLE Weaver_System_Date
GO
CREATE TABLE Weaver_System_Date(
id INT IDENTITY(1,1) PRIMARY KEY,
systemdate DATE
)
GO
DECLARE @BEGIN_DATE DATETIME
SELECT @BEGIN_DATE = '2000-01-01'
WHILE @BEGIN_DATE <='2100-12-31'
BEGIN
INSERT INTO Weaver_System_Date (systemdate) VALUES (@BEGIN_DATE)
SELECT @BEGIN_DATE = DATEADD(DD, 1, @BEGIN_DATE)
END
GO