| Line 31... |
Line 31... |
| 31 |
CASE WHEN IsNumeric(tt.ts_user_02) = 0 THEN 0
|
31 |
CASE WHEN IsNumeric(tt.ts_user_02) = 0 THEN 0
|
| 32 |
WHEN (CharIndex('.', tt.ts_user_02) > 0) THEN CONVERT(float,tt.ts_user_02) * 60.0
|
32 |
WHEN (CharIndex('.', tt.ts_user_02) > 0) THEN CONVERT(float,tt.ts_user_02) * 60.0
|
| 33 |
ELSE CONVERT(float,tt.ts_user_02) END
|
33 |
ELSE CONVERT(float,tt.ts_user_02) END
|
| 34 |
END AS est_run_time,
|
34 |
END AS est_run_time,
|
| 35 |
CASE WHEN IsNumeric(tt.rn_user_01) = 0 THEN 0
|
35 |
CASE WHEN IsNumeric(tt.rn_user_01) = 0 THEN 0
|
| 36 |
WHEN (CONVERT(float,tt.rn_user_01) > 1000) THEN 0
|
- |
|
| 37 |
WHEN (CharIndex('.', tt.rn_user_01) > 0) THEN CONVERT(float,tt.rn_user_01) * 60.0
|
36 |
WHEN (CharIndex('.', tt.rn_user_01) > 0) THEN CONVERT(float,tt.rn_user_01) * 60.0
|
| 38 |
ELSE CONVERT(float,tt.rn_user_01) END AS act_run_time,
|
37 |
ELSE CONVERT(float,tt.rn_user_01) END AS act_run_time,
|
| 39 |
CASE WHEN IsNumeric(tt.rn_user_02) = 0 THEN 0
|
38 |
CASE WHEN IsNumeric(tt.rn_user_02) = 0 THEN 0
|
| 40 |
WHEN (CONVERT(float,tt.rn_user_02) > 1000) THEN 0
|
39 |
WHEN (CONVERT(float,tt.rn_user_02) > 1000) THEN 0
|
| 41 |
WHEN (CharIndex('.', tt.rn_user_02) > 0) THEN CONVERT(float,tt.rn_user_02) * 60.0
|
40 |
WHEN (CharIndex('.', tt.rn_user_02) > 0) THEN CONVERT(float,tt.rn_user_02) * 60.0
|
| Line 75... |
Line 74... |
| 75 |
--and tt.rn_execution_date >= '20111001' AND tt.rn_execution_date < '20111101'
|
74 |
--and tt.rn_execution_date >= '20111001' AND tt.rn_execution_date < '20111101'
|
| 76 |
and tt.rn_tester_name IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
|
75 |
and tt.rn_tester_name IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
|
| 77 |
'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
|
76 |
'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
|
| 78 |
'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
|
77 |
'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
|
| 79 |
'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
|
78 |
'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
|
| 80 |
'wwong','mchua','dmonahan')
|
79 |
'wwong','mchua','dmonahan','awehalle')
|
| 81 |
) dd
|
80 |
) dd
|
| 82 |
GROUP BY dd.test_month,dd.project
|
81 |
GROUP BY dd.test_month,dd.project
|
| 83 |
ORDER BY dd.test_month,dd.project;
|
82 |
ORDER BY dd.test_month,dd.project;
|
| 84 |
|
83 |
|