「銷售實績」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==銷售預估== <sql> SELECT MA001,MA002,TD013,TD001,TD002,TD003,TD004,TD008,TD010,TD011,TD012*TC009 AS TD012NT, (SELECT CASE WHEN MB007='301' AND MA019<>'401' THEN 'FWH' WHEN MB007...
 
Root​(留言 | 貢獻)
第13行: 第13行:
WHEN MA001='0156' THEN SUBSTRING(CONVERT(varchar(100),DATEADD(MONTH, 1,TD013), 112),1,6)
WHEN MA001='0156' THEN SUBSTRING(CONVERT(varchar(100),DATEADD(MONTH, 1,TD013), 112),1,6)
WHEN MA001='197B' THEN SUBSTRING(TD013,1,6)
WHEN MA001='197B' THEN SUBSTRING(TD013,1,6)
WHEN CONVERT(
WHEN SUBSTRING(CONVERT(
varchar(100),
varchar(100),
(SELECT CASE  
(SELECT CASE  
第24行: 第24行:
(SELECT MP004 FROM CMSMP WHERE MP004=CONVERT(varchar(100),DATEADD(DAY, 1, TD013),112)) THEN DATEADD(DAY, 2, TD013)
(SELECT MP004 FROM CMSMP WHERE MP004=CONVERT(varchar(100),DATEADD(DAY, 1, TD013),112)) THEN DATEADD(DAY, 2, TD013)
ELSE  DATEADD(DAY, 1, TD013)  
ELSE  DATEADD(DAY, 1, TD013)  
END), 112) > MA043  
END), 112),7,2) > MA043  


THEN  SUBSTRING(CONVERT(varchar(100),DATEADD(MONTH, 1, TD013),112),1,6)
THEN  SUBSTRING(CONVERT(varchar(100),DATEADD(MONTH, 1, TD013),112),1,6)

於 2015年12月28日 (一) 13:02 的修訂

銷售預估

<sql> SELECT MA001,MA002,TD013,TD001,TD002,TD003,TD004,TD008,TD010,TD011,TD012*TC009 AS TD012NT, (SELECT CASE WHEN MB007='301' AND MA019<>'401' THEN 'FWH' WHEN MB007='302' AND MA019<>'401' THEN 'FW' WHEN MB007='303' AND MA019<>'401' THEN 'FP' WHEN MB007='301' AND MA019='401' THEN 'WH' WHEN MB007='302' AND MA019='401' THEN 'W' WHEN MB007='303' AND MA019='401' THEN 'P' ELSE MB007 END) AS MB007,TD013 AS TD013A,MA043, (SELECT CASE WHEN MA001='0156' THEN SUBSTRING(CONVERT(varchar(100),DATEADD(MONTH, 1,TD013), 112),1,6) WHEN MA001='197B' THEN SUBSTRING(TD013,1,6) WHEN SUBSTRING(CONVERT( varchar(100), (SELECT CASE WHEN EXISTS (SELECT MP004 FROM CMSMP WHERE MP004=CONVERT(varchar(100),DATEADD(DAY, 1, TD013),112)) AND EXISTS (SELECT MP004 FROM CMSMP WHERE MP004=CONVERT(varchar(100),DATEADD(DAY, 2, TD013),112)) THEN DATEADD(DAY, 3, TD013)

 WHEN EXISTS 

(SELECT MP004 FROM CMSMP WHERE MP004=CONVERT(varchar(100),DATEADD(DAY, 1, TD013),112)) THEN DATEADD(DAY, 2, TD013) ELSE DATEADD(DAY, 1, TD013) END), 112),7,2) > MA043

THEN SUBSTRING(CONVERT(varchar(100),DATEADD(MONTH, 1, TD013),112),1,6) ELSE

SUBSTRING(TD013,1,6) 

END) AS PRDATE

FROM v_COPTCD JOIN INVMB ON MB001=TD004 JOIN COPMA ON MA001=TC004 WHERE TD021<>'V' AND TD001<>'400' </sql>