| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
5.8469 |
2017-06-05 00:00:00.0 |
5.8469 |
474 |
| 2 |
15.6691 |
2017-06-06 00:00:00.0 |
9.8222 |
474 |
| 3 |
25.5038 |
2017-06-07 00:00:00.0 |
9.8347 |
474 |
| 4 |
35.4840 |
2017-06-08 00:00:00.0 |
9.9802 |
474 |
| 5 |
45.1121 |
2017-06-09 00:00:00.0 |
9.6281 |
474 |
| 6 |
54.9468 |
2017-06-10 00:00:00.0 |
9.8347 |
474 |
| 7 |
64.8162 |
2017-06-11 00:00:00.0 |
9.8694 |
474 |
| 8 |
74.3259 |
2017-06-12 00:00:00.0 |
9.5097 |
474 |
| 9 |
83.1504 |
2017-06-13 00:00:00.0 |
8.8245 |
474 |
| 10 |
92.4137 |
2017-06-14 00:00:00.0 |
9.2633 |
474 |
| 11 |
101.1887 |
2017-06-15 00:00:00.0 |
8.7750 |
474 |
| 12 |
110.4520 |
2017-06-16 00:00:00.0 |
9.2633 |
474 |
| 13 |
118.3622 |
2017-06-17 00:00:00.0 |
7.9102 |
474 |
| 14 |
125.9331 |
2017-06-18 00:00:00.0 |
7.5709 |
474 |
| 15 |
134.2168 |
2017-06-19 00:00:00.0 |
8.2837 |
474 |
| 16 |
143.0413 |
2017-06-20 00:00:00.0 |
8.8245 |
474 |
| 17 |
152.1413 |
2017-06-21 00:00:00.0 |
9.1000 |
474 |
| 18 |
161.0617 |
2017-06-22 00:00:00.0 |
8.9204 |
474 |
| 19 |
168.4898 |
2017-06-23 00:00:00.0 |
7.4281 |
474 |
| 20 |
172.5388 |
2017-06-24 00:00:00.0 |
4.0490 |
474 |
| 21 |
178.3138 |
2017-06-25 00:00:00.0 |
5.7750 |
474 |
| 22 |
187.0888 |
2017-06-26 00:00:00.0 |
8.7750 |
474 |
| 23 |
197.0378 |
2017-06-27 00:00:00.0 |
9.9490 |
474 |
| 24 |
206.8725 |
2017-06-28 00:00:00.0 |
9.8347 |
474 |
| 25 |
216.3169 |
2017-06-29 00:00:00.0 |
9.4444 |
474 |
| 26 |
225.1414 |
2017-06-30 00:00:00.0 |
8.8245 |
474 |
| 27 |
233.8144 |
2017-07-01 00:00:00.0 |
8.6730 |
474 |
| 28 |
242.5894 |
2017-07-02 00:00:00.0 |
8.7750 |
474 |
| 29 |
252.5848 |
2017-07-03 00:00:00.0 |
9.9954 |
474 |
| 30 |
261.6848 |
2017-07-04 00:00:00.0 |
9.1000 |
474 |
| 31 |
270.7848 |
2017-07-05 00:00:00.0 |
9.1000 |
474 |
| 32 |
280.3391 |
2017-07-06 00:00:00.0 |
9.5543 |
474 |
| 33 |
290.1917 |
2017-07-07 00:00:00.0 |
9.8526 |
474 |
| 34 |
300.0139 |
2017-07-08 00:00:00.0 |
9.8222 |
474 |
| 35 |
309.9349 |
2017-07-09 00:00:00.0 |
9.9210 |
474 |
| 36 |
319.8349 |
2017-07-10 00:00:00.0 |
9.9000 |
474 |
| 37 |
329.8329 |
2017-07-11 00:00:00.0 |
9.9980 |
474 |
| 38 |
338.1166 |
2017-07-12 00:00:00.0 |
8.2837 |
474 |
| 39 |
347.3003 |
2017-07-13 00:00:00.0 |
9.1837 |
474 |
| 40 |
357.2590 |
2017-07-14 00:00:00.0 |
9.9587 |
474 |
| 41 |
367.2544 |
2017-07-15 00:00:00.0 |
9.9954 |
474 |
| 42 |
377.1927 |
2017-07-16 00:00:00.0 |
9.9383 |
474 |
| 43 |
386.9149 |
2017-07-17 00:00:00.0 |
9.7222 |
474 |
| 44 |
396.6210 |
2017-07-18 00:00:00.0 |
9.7061 |
474 |
| 45 |
405.4940 |
2017-07-19 00:00:00.0 |
8.8730 |
474 |
| 46 |
415.4205 |
2017-07-20 00:00:00.0 |
9.9265 |
474 |
| 47 |
425.4021 |
2017-07-21 00:00:00.0 |
9.9816 |
474 |
| 48 |
435.0021 |
2017-07-22 00:00:00.0 |
9.6000 |
474 |
| 49 |
444.9771 |
2017-07-23 00:00:00.0 |
9.9750 |
474 |
| 50 |
454.8277 |
2017-07-24 00:00:00.0 |
9.8506 |
474 |
| 51 |
464.8272 |
2017-07-25 00:00:00.0 |
9.9995 |
474 |
| 52 |
474.8223 |
2017-07-26 00:00:00.0 |
9.9951 |
474 |
| 53 |
484.6988 |
2017-07-27 00:00:00.0 |
9.8765 |
474 |
| 54 |
493.9272 |
2017-07-28 00:00:00.0 |
9.2284 |
474 |
| 55 |
503.6112 |
2017-07-29 00:00:00.0 |
9.6840 |
474 |
| 56 |
512.2668 |
2017-07-30 00:00:00.0 |
8.6556 |
474 |
| 57 |
520.0890 |
2017-07-31 00:00:00.0 |
7.8222 |
474 |
| 58 |
530.0563 |
2017-08-01 00:00:00.0 |
9.9673 |
474 |
| 59 |
537.7660 |
2017-08-02 00:00:00.0 |
7.7097 |
474 |
| 60 |
547.1048 |
2017-08-03 00:00:00.0 |
9.3388 |
474 |
| 61 |
556.6145 |
2017-08-04 00:00:00.0 |
9.5097 |
474 |
| 62 |
565.9160 |
2017-08-05 00:00:00.0 |
9.3015 |
474 |
| 63 |
575.2910 |
2017-08-06 00:00:00.0 |
9.3750 |
474 |
| 64 |
585.1604 |
2017-08-07 00:00:00.0 |
9.8694 |
474 |
| 65 |
594.9762 |
2017-08-08 00:00:00.0 |
9.8158 |
474 |
| 66 |
603.9430 |
2017-08-09 00:00:00.0 |
8.9668 |
474 |
| 67 |
613.6961 |
2017-08-10 00:00:00.0 |
9.7531 |
474 |
| 68 |
623.2961 |
2017-08-11 00:00:00.0 |
9.6000 |
474 |
| 69 |
633.0492 |
2017-08-12 00:00:00.0 |
9.7531 |
474 |
| 70 |
642.8242 |
2017-08-13 00:00:00.0 |
9.7750 |
474 |
| 71 |
652.7380 |
2017-08-14 00:00:00.0 |
9.9138 |
474 |
| 72 |
662.3931 |
2017-08-15 00:00:00.0 |
9.6551 |
474 |
| 73 |
672.2089 |
2017-08-16 00:00:00.0 |
9.8158 |
474 |
| 74 |
682.0048 |
2017-08-17 00:00:00.0 |
9.7959 |
474 |
| 75 |
691.9538 |
2017-08-18 00:00:00.0 |
9.9490 |
474 |
| 76 |
701.7760 |
2017-08-19 00:00:00.0 |
9.8222 |
474 |
| 77 |
711.6286 |
2017-08-20 00:00:00.0 |
9.8526 |
474 |
| 78 |
720.0852 |
2017-08-21 00:00:00.0 |
8.4566 |
474 |
| 79 |
728.9582 |
2017-08-22 00:00:00.0 |
8.8730 |
474 |
| 80 |
735.2720 |
2017-08-23 00:00:00.0 |
6.3138 |
474 |
| 81 |
742.6271 |
2017-08-24 00:00:00.0 |
7.3551 |
474 |
| 82 |
752.1047 |
2017-08-25 00:00:00.0 |
9.4776 |
474 |
| 83 |
761.6144 |
2017-08-26 00:00:00.0 |
9.5097 |
474 |
| 84 |
771.4996 |
2017-08-27 00:00:00.0 |
9.8852 |
474 |
| 85 |
781.2576 |
2017-08-28 00:00:00.0 |
9.7580 |
474 |
| 86 |
790.7638 |
2017-08-29 00:00:00.0 |
9.5062 |
474 |
| 87 |
800.1026 |
2017-08-30 00:00:00.0 |
9.3388 |
474 |
| 88 |
809.5802 |
2017-08-31 00:00:00.0 |
9.4776 |
474 |
| 89 |
819.4328 |
2017-09-01 00:00:00.0 |
9.8526 |
474 |
| 90 |
829.2854 |
2017-09-02 00:00:00.0 |
9.8526 |
474 |
| 91 |
839.1548 |
2017-09-03 00:00:00.0 |
9.8694 |
474 |
| 92 |
847.8793 |
2017-09-04 00:00:00.0 |
8.7245 |
474 |
|
| CACHED |
false |
| EXECUTIONTIME |
5 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '474') AND ddate < '2020-11-01'
ORDER BY ddate ASC |
