--1.数据集-------------------------------名称:STEPMOVE--类型:数据库查询--运行状态:已执行--运行耗费时间:777ms--参数:---HISDATE:20200901,20200902,20200903,20200904,20200905,20200906,20200907,20200908,20200909,20200910,20200911,20200912,20200913,20200914,20200915,20200916,20200917,20200918,20200919,20200920,20200921,20200922,20200923--内容:SELECT LOTID, PRODUCTNAME, TECHNOLOGY AS TECH, A.STAGE, TRACKOUTQTY AS QTY, LOTTYPE, PRIORITY, TXNTIMESTAMP, STEPDESC, USERID FROM (SELECT *FROM SDB_TB_WIP_TITO_HISTWHERE TRACKINTIME>='20200901,20200902,20200903,20200904,20200905,20200906,20200907,20200908,20200909,20200910,20200911,20200912,20200913,20200914,20200915,20200916,20200917,20200918,20200919,20200920,20200921,20200922,20200923'||' 073000000' and TRACKINTIME< '20200901,20200902,20200903,20200904,20200905,20200906,20200907,20200908,20200909,20200910,20200911,20200912,20200913,20200914,20200915,20200916,20200917,20200918,20200919,20200920,20200921,20200922,20200923'||' 193000000'--TRACKOUTTIME >= '" + beginTime + @"'--AND TRACKOUTTIME < '" + endTime + @"'--AND AND PRIORITY NOT IN ('7', '8', '9') AND TRIM(LOTTYPE) NOT IN ('C', 'D', 'Z', 'V', 'Y', 'X')--AND (TRIM(LOTTYPE) IN ('P','R','M','L','T','LF') OR TRIM(LOTTYPE) LIKE 'E%')--" + swhere + @") A,(SELECT DISTINCT FAB, STAGEFROM SDB_TB_INFO_STAGEWHERE STAGEGROUP = 'ALL') BWHERE A.STAGE = B.STAGE
|