Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Incident Reports » Incident Reports Reported for Version 4.25 » View Incident Report |
Serious |
Reported By: Eduardo Pereira Reported On: 12/27/2007 For: Version 4.25 Build 7 |
SELECT CONCAT(POINTNAME WITH '.X') AS POINTNAME, STDDEV(X) * 6 AS SIGMA, MIN(X) AS MINIMA, MAX(X) AS MAXIMA, AVG(X) AS MEDIA, MAX(X) - MIN(X) AS RANGE, CAST((((AVG(ZEROX) + AVG(LINFX)) - (AVG(ZEROX) - AVG(LINFX))) / (STDDEV(X) * 6)), FLOAT) AS CP, IF((((AVG(ZEROX) + AVG(LINFX)) - AVG(X)) / (STDDEV(X) * 3)) < ((AVG(X) - (AVG(ZEROX) - AVG(LINFX))) / (STDDEV(X) * 3)) THEN (((AVG(ZEROX) + AVG(LINFX)) - AVG(X)) / (STDDEV(X) * 3)) ELSE ((AVG(X) - (AVG(ZEROX) - AVG(LINFX))) / (STDDEV(X) * 3))) AS CPK FROM TBPOINTS WHERE FKID < 200 AND X <> NULL GROUP BY POINTNAME UNION SELECT CONCAT(POINTNAME WITH '.Y') AS POINTNAME, STDDEV(Y) * 6 AS SIGMA, MIN(Y) AS MINIMA, MAX(Y) AS MAXIMA, AVG(Y) AS MEDIA, MAX(Y) - MIN(Y) AS RANGE, CAST((((AVG(ZEROY) + AVG(LINFY)) - (AVG(ZEROY) - AVG(LINFY))) / (STDDEV(Y) * 6)), FLOAT) AS CP, IF((((AVG(ZEROY) + AVG(LINFY)) - AVG(Y)) / (STDDEV(Y) * 3)) < ((AVG(Y) - (AVG(ZEROY) - AVG(LINFY))) / (STDDEV(Y) * 3)) THEN (((AVG(ZEROY) + AVG(LINFY)) - AVG(Y)) / (STDDEV(Y) * 3)) ELSE ((AVG(Y) - (AVG(ZEROY) - AVG(LINFY))) / (STDDEV(Y) * 3))) AS CPK FROM TBPOINTS WHERE FKID < 200 AND Y <> NULL GROUP BY POINTNAME UNION SELECT CONCAT(POINTNAME WITH '.Z') AS POINTNAME, STDDEV(Z) * 6 AS SIGMA, MIN(Z) AS MINIMA, MAX(Z) AS MAXIMA, AVG(Z) AS MEDIA, MAX(Z) - MIN(Z) AS RANGE, CAST((((AVG(ZEROZ) + AVG(LINFZ)) - (AVG(ZEROZ) - AVG(LINFZ))) / (STDDEV(Z) * 6)), FLOAT) AS CP, IF((((AVG(ZEROZ) + AVG(LINFZ)) - AVG(Z)) / (STDDEV(Z) * 3)) < ((AVG(Z) - (AVG(ZEROZ) - AVG(LINFZ))) / (STDDEV(Z) * 3)) THEN (((AVG(ZEROZ) + AVG(LINFZ)) - AVG(Z)) / (STDDEV(Z) * 3)) ELSE ((AVG(Z) - (AVG(ZEROZ) - AVG(LINFZ))) / (STDDEV(Z) * 3))) AS CPK FROM TBPOINTS WHERE FKID < 200 AND Z <> NULL GROUP BY POINTNAME ORDER BY CP
This web page was last updated on Wednesday, March 20, 2024 at 07:22 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |