1
vSET ANSI_NULLS
ON
2
GO
3
4
SET
QUOTED_IDENTIFIER
ON
5
GO
6
7
/*
--------------------------------------------------------
8
*generate Date demention
9
*@startdate 01/01/2010
10
*@enddate 12/30/2010
11
---------------------------------------------------------
*/
12
13
CREATE
PROCEDURE
dbo.AddDateTime
14
@startdate
datetime
,
15
@enddate
datetime
16
AS
17
declare
@i
int
18
set
@i
=
1
19
20
while
(
DATEDIFF
(DD,
@startdate
,
@enddate
)
>=
0
)
21
begin
22
23
insert
into
[
ReportServer
]
.
[
dbo
]
.
[
D_DATE
]
(
24
[
DATE_KEY
]
,
--
primarykey
25
[
DATE
]
,
--
datetime
26
[
FULL_DATE_DESCRIPTION
]
,
--
detail date
27
[
DAY_OF_WEEK
]
,
--
day of week from 1 to 6
28
[
CALENDAR_MONTH
]
,
--
month of year from 1 to 12
29
[
CALENDAR_YEAR
]
,
--
year
30
[
FISCAL_YEAR_MONTH
]
,
--
fiscal year
31
[