22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT P.NAME,WH.WORKORDER,(CASE substring(T.NAME,1,1) WHEN 'L' THEN 'LPE' WHEN 'A' THEN 'ASM' ELSE P.LINE END) as Line
,P.WAFERSIZE,WH.LOTID,WH.RUNNO
,COUNT(DISTINCT WH.WAFERID) AS MoveInQty
,SUM(CASE WHEN LEN(WH.DEFECTCODE)=0 THEN 0 ELSE 1 END) AS ScrapQty
,ROUND((COUNT(DISTINCT WH.WAFERID) * ((CAST(P.WAFERSIZE AS FLOAT) * CAST(P.WAFERSIZE AS FLOAT)) / 36)),2) AS TranslateQty
,S.NAME,T.NAME,WH.OPERATORID
,WH.MOVEINTIME,WH.MOVEOUTTIME
FROM WAFERHISTORY WH,Shopfloornode S,TOOL T,WORKORDER WO,PRODUCT P
WHERE WH.STEPID=S.SHOPFLOORNODEID AND WH.TOOLID=T.ID
AND WH.WORKORDER=WO.WorkOrderID
--AND WO.WorkOrderType IN (3,7,11)
AND WO.ProductName=P.NAME
AND T.TOOLCLASS='M'
AND S.NAME = '6320'
AND WH.MOVEOUTTIME > '2013-10-07 00:00:00'
AND WH.MOVEOUTTIME < '2013-10-10 00:00:00'
GROUP BY S.NAME,WH.WORKORDER,WH.LOTID,T.NAME,P.WAFERSIZE, P.NAME,WH.RUNNO,p.Line,WH.OPERATORID,WH.MOVEINTIME,WH.MOVEOUTTIME;