1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
CREATE TABLE DateLookup
(
DateKey INT PRIMARY KEY,
Date_Begin DATETIME,
Date_End Datetime,
)
go
DECLARE @Date DATETIME
DECLARE @Date2 DATETIME
SET @Date = (select MIN(startdate) from TblPolicy)
SET @Date = DATEADD(month, -1, @Date)
SET @Date2 = (select max(Enddate) from TblPolicy)
SET @Date2 = DATEADD(month, 1, @Date2)
WHILE @Date < @Date2
BEGIN
INSERT INTO DateLookup
(
DateKey, Date_Begin, Date_End
)
SELECT
CONVERT(VARCHAR(8), @Date, 112),
@Date,
DATEADD(month, 1, @Date)
SET @Date = DATEADD(month, 1, @Date)
END |
Partager