加工製程改善計劃

出自TSK WIKI
跳至導覽 跳至搜尋

製程停滯製令金額

<SQL> SELECT TA002,UDF06,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527 ,(SELECT CASE WHEN UDF06=1 THEN CONVERT(VARCHAR,GETDATE(),111) WHEN UDF06=2 AND CHARINDEX('外發', TA510)>0 THEN

      WHEN UDF06=2 AND TA521= THEN CONVERT(VARCHAR,GETDATE(),111) 
      WHEN UDF06=2 AND TA521<> THEN TA521 
      WHEN UDF06=3 AND TA523= THEN TA521
      WHEN UDF06=3 AND TA523<> THEN TA523
      WHEN UDF06=4 AND TA025= THEN TA523
      WHEN UDF06=4 AND TA025<> THEN TA525             

END)ST, (SELECT CASE WHEN UDF06=1 AND TA520 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111)

      WHEN UDF06=1 THEN TA520
      WHEN UDF06=2	AND CHARINDEX('外發', TA510)>0 THEN 	       
      WHEN UDF06=2 AND TA522 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111) 
      WHEN UDF06=2 THEN TA522 
      WHEN UDF06=3 AND TA524 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111) 
      WHEN UDF06=3 THEN TA524
      WHEN UDF06=4 AND TA526 < CONVERT(VARCHAR,GETDATE(),111) THEN CONVERT(VARCHAR,GETDATE(),111) 
      WHEN UDF06=4 AND TA026<> THEN TA525             

END)ED

FROM MOCTA WHERE TA013='Y' AND TA011<>'Y' AND TA011<>'y' AND TA001='5102' AND UDF06 BETWEEN 1 AND 4 </SQL>