「ISO年度筆數計算」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==功能== *計算電線單及採購單筆數,製作品質系統流程績效量測之來源數據 ==電線單別(2301)== <SQL> SELECT COUNT(TH003) AS AMOUNT FROM COPTH JOIN COPTG ON... |
|||
| (未顯示同一使用者於中間所作的 1 次修訂) | |||
| 第1行: | 第1行: | ||
== | ==用途== | ||
*計算電線單及採購單筆數,製作品質系統流程績效量測之來源數據 | *計算電線單及採購單筆數,製作品質系統流程績效量測之來源數據 | ||
==電線單別(2301)== | ==電線單別(2301)== | ||
<SQL> | <SQL> | ||
| 第9行: | 第10行: | ||
==採購單別(3302)== | ==採購單別(3302)== | ||
<SQL> | <SQL> | ||
/ | /*以單別*/ | ||
SELECT TD001,TD002,TD003 AS AMOUNT FROM PURTD | SELECT TD001,TD002,TD003 AS AMOUNT FROM PURTD | ||
JOIN PURTC ON TD001=TC001 AND TC002=TD002 | JOIN PURTC ON TD001=TC001 AND TC002=TD002 | ||
WHERE TC003 LIKE '2016%' AND (TD001='3302' OR TD001='3301') AND TD018='Y' | WHERE TC003 LIKE '2016%' AND (TD001='3302' OR TD001='3301') AND TD018='Y' | ||
/ | /*以填單寫人員*/ | ||
SELECT TD001,TD002,TD003 AS AMOUNT FROM PURTD | SELECT TD001,TD002,TD003 AS AMOUNT FROM PURTD | ||
JOIN PURTC ON TD001=TC001 AND TC002=TD002 | JOIN PURTC ON TD001=TC001 AND TC002=TD002 | ||
WHERE TC003 LIKE '2016%' AND PURTC.CREATOR='B0093' AND TD018='Y' | WHERE TC003 LIKE '2016%' AND PURTC.CREATOR='B0093' AND TD018='Y' | ||
</SQL> | </SQL> | ||
於 2017年2月8日 (三) 13:54 的最新修訂
用途
- 計算電線單及採購單筆數,製作品質系統流程績效量測之來源數據
電線單別(2301)
<SQL> SELECT COUNT(TH003) AS AMOUNT FROM COPTH JOIN COPTG ON TH001=TG001 AND TH002=TG002 WHERE TG003 LIKE '2016%' AND TH001='2301' AND TH020='Y' </SQL>
採購單別(3302)
<SQL> /*以單別*/ SELECT TD001,TD002,TD003 AS AMOUNT FROM PURTD JOIN PURTC ON TD001=TC001 AND TC002=TD002 WHERE TC003 LIKE '2016%' AND (TD001='3302' OR TD001='3301') AND TD018='Y'
/*以填單寫人員*/ SELECT TD001,TD002,TD003 AS AMOUNT FROM PURTD JOIN PURTC ON TD001=TC001 AND TC002=TD002 WHERE TC003 LIKE '2016%' AND PURTC.CREATOR='B0093' AND TD018='Y' </SQL>