数据仓库的时间维度表 Sql

最新推荐文章于 2024-06-26 07:30:00 发布

lglgsy456

最新推荐文章于 2024-06-26 07:30:00 发布

阅读量5.4k

点赞数 1

分类专栏： BI

本文链接：https://blog.csdn.net/lglgsy456/article/details/41982477

版权

BI 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

Declare @BeginDate Datetime
Set @BeginDate='2011-1-1'
While @BeginDate<'2015-12-31'
Begin
Insert Into [InstagramDataDW].[dbo].[Dim_Date]
Select CONVERT(varchar(10),@BeginDate,112) As DateKey,Year(@BeginDate) as Year,
Case When Month(@BeginDate)>6 then 2 Else 1 End As HalfYear,
DATEPART(QUARTER,@BeginDate) As Quarter,
Case When DATEPART(QUARTER,@BeginDate)=1 Then 'one'
When DATEPART(QUARTER,@BeginDate)=2 Then 'two'
When DATEPART(QUARTER,@BeginDate)=3 Then 'three'
Else 'four' End As QuarterEN,
Month(@BeginDate) As Month,
DATEPART(WEEK,@BeginDate) As [WeekOfYear],
DateName(WEEKDAY,@BeginDate) As Week,
Day(@BeginDate) As Day,
CONVERT(varchar(10),@BeginDate,120) As Date
Set @BeginDate=DATEADD(DAY,1,@BeginDate)
End