抽取已有表的部分数据构造新表

一、建一个空dimDate表

 

1.       date，yy，mm插入dimDate表中

Insert into dimDate(date,yy,quarter,mm)

select date,yy,'',mm

from SiteDayAsse

order by date

 

2.    构造quarter

 

update dimDate set quarter='1' where mm='01' or mm='02' or mm='03'

update dimDate set quarter='2' where mm='04' mm='05' or mm='06'

update dimDate set quarter='3' where mm='07'or  mm='08' or mm='09'

update dimDate set quarter='4' where mm='10'or  mm='11' or mm='12'