1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| SELECT
SUM(CASE WHEN PPQCStatus = 0 THEN 1 END) + SUM(CASE WHEN PPQCStatus LIKE '%' THEN 1 END) AS Pourcentage,
SUM(CASE WHEN PPQCStatus = 1 THEN 1 END) AS Nbr_First_NG,
SUM(CASE WHEN PPQCStatus = 0 THEN 1 END) AS Nbr_First_OK,
SUM(CASE WHEN PPQCStatus LIKE '%' THEN 1 END) AS Production_Volume_,
Convert(int, Month([PPTimeStamp])) AS Month,
Convert(int, Year ([PPTimeStamp])) AS Year,
PPProcessNumber
FROM
passage
WHERE
PPProcessNumber IN ('3290', '3480')
AND PPPassageNumber = '1'
AND PPTimeStamp > '2010-06-01 00:00:00'
AND PPTimeStamp < '2010-06-30 23:59:59'
GROUP BY
Convert(int, Month([PPTimeStamp])),
Convert(int, Year ([PPTimeStamp])),
PPProcessNumber
ORDER BY
Convert(int, Month([PPTimeStamp])) asc,
Convert(int, Year ([PPTimeStamp])) asc,
PPProcessNumber asc; |
Partager