22,210
社区成员
发帖
与我相关
我的任务
分享
update ds_week set
cnt = a.cnt + b.cnt
from ds_day a
join ds_week b on a.number=b.number and weekid(a.day)=b.weekid
insert into ds_week
select weekid(a.day), number, cnt
from ds_day a
where day = @theday
and not exists (select 1 from ds_week b
where b.number=a.number and b.weekid=weekid(a.day))
CREATE VIEW vw_WeekReport_1
AS
SELECT 时间,手机号,sum(上线次数) from 天表 where timeid in (第1周id) group by 手机号
GO
CREATE VIEW vw_WeekReport_2
AS
SELECT 时间,手机号,sum(上线次数) from 天表 where timeid in (第2周id) group by 手机号
GO
....
天表的聚集索引建立在timeid上
而索引view的聚集索引可建在手机号上