--预设方案--
select SRPTABLE6.code as '客户编码',SRPTABLE6.shortname as '客户简称',SRPTABLE6.name as '客户全称',YEAR(SRPTABLE1.billdate) as '年份',SUM(case when MONTH(SRPTABLE1.billdate)=1 then (SRPTABLE1.unitprice*SRPTABLE1.unitqty) end) as '1月',SUM(case when MONTH(SRPTABLE1.billdate)=2 then (SRPTABLE1.unitprice*SRPTABLE1.unitqty) end) as '2月',SUM(case when MONTH(SRPTABLE1.billdate)=3 then (SRPTABLE1.unitprice*SRPTABLE1.unitqty) end) as '3月',SUM(case when MONTH(SRPTABLE1.billdate)=4 then (SRPTABLE1.unitprice*SRPTABLE1.unitqty) end) as '4月',SUM(case when MONTH(SRPTABLE1.billdate)=5 then (SRPTABLE1.unitprice*SRPTABLE1.unitqty) end) as '5月',SUM(case when MONTH(SRPTABLE1.billdate)=6 then (SRPTABLE1.unitprice*SRPTABLE1.unitqty) end) as '6月',SUM(case when MONTH(SRPTABLE1.billdate)=7 then (SRPTABLE1.unitprice*SRPTABLE1.unitqty) end) as '7月',SUM(case when MONTH(SRPTABLE1.billdate