「銷售目標」:修訂間差異
跳至導覽
跳至搜尋
| 第5行: | 第5行: | ||
*用貓匯入後即完成更新 | *用貓匯入後即完成更新 | ||
*PS. S,P 改為P ; FS,FP 改為FP | *PS. S,P 改為P ; FS,FP 改為FP | ||
==計算達成率== | |||
<SQL> | |||
SELECT A,AMONEY,BMONEY,AMONEY/BMONEY*100 AS CC FROM(SELECT A,SUM(AMONEY) AS AMONEY FROM | |||
(SELECT SUBSTRING(statementDATE,1,4) AS A,SUM(TH037)AS AMONEY FROM v_KINDOFCOPTH WHERE statementDATE >= '20160101' | |||
GROUP BY statementDATE )AS X GROUP BY A)Y | |||
JOIN | |||
(SELECT B,SUM(BMONEY)AS BMONEY FROM(SELECT SUBSTRING(PRMONTH,1,4) AS B,SUM(PRSA) BMONEY FROM | |||
LSDTEST.dbo.PRSALE WHERE PRMONTH >='20160101' GROUP BY PRMONTH)U GROUP BY B)V | |||
ON A=B | |||
</SQL> | |||
於 2017年3月6日 (一) 16:27 的修訂
更新銷售目標資料庫
- 資料庫位置:LSDTEST.dbo.PRSALE
- 開S碟銷售實績下的各年度營業目標
- 將資料轉成 年度 金額 分類 備考後存成xls(善用複製轉置)
- 用貓匯入後即完成更新
- PS. S,P 改為P ; FS,FP 改為FP
計算達成率
<SQL> SELECT A,AMONEY,BMONEY,AMONEY/BMONEY*100 AS CC FROM(SELECT A,SUM(AMONEY) AS AMONEY FROM (SELECT SUBSTRING(statementDATE,1,4) AS A,SUM(TH037)AS AMONEY FROM v_KINDOFCOPTH WHERE statementDATE >= '20160101' GROUP BY statementDATE )AS X GROUP BY A)Y JOIN (SELECT B,SUM(BMONEY)AS BMONEY FROM(SELECT SUBSTRING(PRMONTH,1,4) AS B,SUM(PRSA) BMONEY FROM LSDTEST.dbo.PRSALE WHERE PRMONTH >='20160101' GROUP BY PRMONTH)U GROUP BY B)V ON A=B </SQL>