「ERP自動寄發郵件」:修訂間差異
跳至導覽
跳至搜尋
新頁面: ==超時單據== *每日超過14:00建立當日出貨之銷貨單 <sql> SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X JOIN COPTG Y ON... |
|||
| 第2行: | 第2行: | ||
*每日超過14:00建立當日出貨之銷貨單 | *每日超過14:00建立當日出貨之銷貨單 | ||
<sql> | <sql> | ||
SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X | SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME | ||
FROM COPTH X | |||
JOIN COPTG Y ON TH001=TG001 AND TH002=TG002 | JOIN COPTG Y ON TH001=TG001 AND TH002=TG002 | ||
JOIN COPMA ON MA001=TG004 | JOIN COPMA ON MA001=TG004 | ||
於 2017年1月19日 (四) 16:34 的最新修訂
超時單據
- 每日超過14:00建立當日出貨之銷貨單
<sql> SELECT TH001,TH002,TH003,MA002,TH004,TH005,TH006,TG003,X.CREATE_DATE,X.CREATE_TIME FROM COPTH X JOIN COPTG Y ON TH001=TG001 AND TH002=TG002 JOIN COPMA ON MA001=TG004 WHERE TG003 = CONVERT(VARCHAR,GETDATE(),112) AND X.CREATE_DATE=CONVERT(VARCHAR,GETDATE(),112) AND X.CREATE_TIME >'14:00:00' AND ( TH001='2302' OR TH001='2303') AND TH020='N' </sql>