客户分析--查询日期用会计期间比制单日期取年月快

--客户分析

select
ga.iperiod as 月,ga.iyear as 年,
(select case when dep.cDepCode is null then dep1.cDepCode
else dep.cDepCode end) as 部门编码,
(select case when dep.cDepName is null then dep1.cDepName
else dep.cDepName end) as 部门,
cusc1.cCCCode as 省份编码,cusc1.cCCName as 省份,
cusc.cCCCode as 客户分类编码,cusc.cCCName as 客户分类,cust.cCusCode as 客户编码,cust.cCusName as 客户名称,
sum(case when ga.ccode in ('某某科目编码') then ga.mc end) as 某某科目
from GL_accvouch ga
left join customer cust on ga.ccus_id = cust.cCusCode
left join CustomerClass cusc on cust.cCCCode = cusc.cCCCode
left join code cod on cod.ccode = ga.ccode and cod.iyear = ga.iyear
left join CustomerClass cusc1 on left(cusc.cCCCode,2) = cusc1.cCCCode
left join DistrictClass disp on cust.cDCCode=disp.cDCCode
left join Department dep on cust.cCusDepart = dep.cDepCode
left join Department dep1 on ga.cdept_id = dep1.cDepCode
where (case when dep.cDepCode is null then dep1.cDepCode else dep.cDepCode end) in ('某某部门')

group by ga.iperiod,ga.iyear,cust.cCusCode,cusc.cCCCode,cusc.cCCName,cust.cCusName,cusc1.cCCCode,cusc1.cCCName,
case when dep.cDepCode is null then dep1.cDepCode else dep.cDepCode end,
case when dep.cDepName is null then dep1.cDepName else dep.cDepName end

 

换成year(dbill_date)和month(dbill_date)就慢如龟爬，不知道是不是哪里触发了全表扫描