「統計報表程式碼」:修訂間差異
跳至導覽
跳至搜尋
| 第9行: | 第9行: | ||
JOIN CMSMV ON MV001=MA016 | JOIN CMSMV ON MV001=MA016 | ||
ORDER BY MA016 | ORDER BY MA016 | ||
</SQL> | |||
==程式碼暫存== | |||
*計算休假日 | |||
<SQL> | |||
SELECT COUNT(MP004) AS MP004 FROM CMSMP WHERE MP004 BETWEEN '20161102' AND '20161107' | |||
</SQL> | </SQL> | ||
於 2016年11月3日 (四) 16:31 的修訂
業務單位
- 統計訂單日及預交日訂單筆數跟金額
<SQL> SELECT MA002,QU,MONEY,MV002 FROM (SELECT TC004,COUNT(TC004)AS QU,SUM(TD076*TD011*TC009)AS MONEY FROM COPTD JOIN COPTC ON TC001=TD001 AND TC002=TD002 WHERE TD013 LIKE '201611%' AND TD021='Y' AND TD016<>'y' AND TD002 BETWEEN '161101000' AND '161102999' AND TD001='2202' GROUP BY TC004)X JOIN COPMA ON MA001=TC004 JOIN CMSMV ON MV001=MA016 ORDER BY MA016 </SQL>
程式碼暫存
- 計算休假日
<SQL> SELECT COUNT(MP004) AS MP004 FROM CMSMP WHERE MP004 BETWEEN '20161102' AND '20161107' </SQL>