| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.9203 |
2026-06-01 00:00:00.0 |
7.9203 |
559 |
| 2 |
16.8637 |
2026-06-02 00:00:00.0 |
8.9434 |
559 |
| 3 |
24.5742 |
2026-06-03 00:00:00.0 |
7.7105 |
559 |
| 4 |
33.5739 |
2026-06-04 00:00:00.0 |
8.9997 |
559 |
| 5 |
42.4082 |
2026-06-05 00:00:00.0 |
8.8343 |
559 |
| 6 |
50.8912 |
2026-06-06 00:00:00.0 |
8.4830 |
559 |
| 7 |
57.9256 |
2026-06-07 00:00:00.0 |
7.0344 |
559 |
| 8 |
62.6995 |
2026-06-08 00:00:00.0 |
4.7739 |
559 |
| 9 |
71.4755 |
2026-06-09 00:00:00.0 |
8.7760 |
559 |
| 10 |
78.1683 |
2026-06-10 00:00:00.0 |
6.6928 |
559 |
| 11 |
87.3396 |
2026-06-11 00:00:00.0 |
9.1713 |
559 |
| 12 |
95.9510 |
2026-06-12 00:00:00.0 |
8.6114 |
559 |
| 13 |
103.2151 |
2026-06-13 00:00:00.0 |
7.2641 |
559 |
| 14 |
109.6585 |
2026-06-14 00:00:00.0 |
6.4434 |
559 |
| 15 |
115.3411 |
2026-06-15 00:00:00.0 |
5.6826 |
559 |
| 16 |
121.7270 |
2026-06-16 00:00:00.0 |
6.3859 |
559 |
| 17 |
127.5973 |
2026-06-17 00:00:00.0 |
5.8703 |
559 |
| 18 |
133.0038 |
2026-06-18 00:00:00.0 |
5.4065 |
559 |
| 19 |
140.0554 |
2026-06-19 00:00:00.0 |
7.0516 |
559 |
| 20 |
147.8508 |
2026-06-20 00:00:00.0 |
7.7954 |
559 |
| 21 |
153.7505 |
2026-06-21 00:00:00.0 |
5.8997 |
559 |
| 22 |
159.4530 |
2026-06-22 00:00:00.0 |
5.7025 |
559 |
| 23 |
166.6822 |
2026-06-23 00:00:00.0 |
7.2292 |
559 |
| 24 |
174.7580 |
2026-06-24 00:00:00.0 |
8.0758 |
559 |
| 25 |
183.5209 |
2026-06-25 00:00:00.0 |
8.7629 |
559 |
| 26 |
190.4659 |
2026-06-26 00:00:00.0 |
6.9450 |
559 |
| 27 |
198.9613 |
2026-06-27 00:00:00.0 |
8.4954 |
559 |
| 28 |
208.3522 |
2026-06-28 00:00:00.0 |
9.3909 |
559 |
| 29 |
217.2389 |
2026-06-29 00:00:00.0 |
8.8867 |
559 |
| 30 |
226.7058 |
2026-06-30 00:00:00.0 |
9.4669 |
559 |
| 31 |
235.9497 |
2026-07-01 00:00:00.0 |
9.2439 |
559 |
| 32 |
245.0398 |
2026-07-02 00:00:00.0 |
9.0901 |
559 |
| 33 |
253.8403 |
2026-07-03 00:00:00.0 |
8.8005 |
559 |
| 34 |
261.8943 |
2026-07-04 00:00:00.0 |
8.0540 |
559 |
| 35 |
269.9571 |
2026-07-05 00:00:00.0 |
8.0628 |
559 |
| 36 |
277.4286 |
2026-07-06 00:00:00.0 |
7.4715 |
559 |
| 37 |
286.2312 |
2026-07-07 00:00:00.0 |
8.8026 |
559 |
| 38 |
294.3723 |
2026-07-08 00:00:00.0 |
8.1411 |
559 |
| 39 |
302.9864 |
2026-07-09 00:00:00.0 |
8.6141 |
559 |
| 40 |
312.2251 |
2026-07-10 00:00:00.0 |
9.2387 |
559 |
| 41 |
320.5705 |
2026-07-11 00:00:00.0 |
8.3454 |
559 |
| 42 |
327.1457 |
2026-07-12 00:00:00.0 |
6.5752 |
559 |
| 43 |
331.5264 |
2026-07-13 00:00:00.0 |
4.3807 |
559 |
| 44 |
336.4242 |
2026-07-14 00:00:00.0 |
4.8978 |
559 |
| 45 |
345.7611 |
2026-07-15 00:00:00.0 |
9.3369 |
559 |
| 46 |
355.3723 |
2026-07-16 00:00:00.0 |
9.6112 |
559 |
| 47 |
363.9806 |
2026-07-17 00:00:00.0 |
8.6083 |
559 |
| 48 |
372.8718 |
2026-07-18 00:00:00.0 |
8.8912 |
559 |
| 49 |
380.8630 |
2026-07-19 00:00:00.0 |
7.9912 |
559 |
| 50 |
388.0807 |
2026-07-20 00:00:00.0 |
7.2177 |
559 |
| 51 |
397.2013 |
2026-07-21 00:00:00.0 |
9.1206 |
559 |
| 52 |
406.1088 |
2026-07-22 00:00:00.0 |
8.9075 |
559 |
| 53 |
414.4310 |
2026-07-23 00:00:00.0 |
8.3222 |
559 |
| 54 |
423.0695 |
2026-07-24 00:00:00.0 |
8.6385 |
559 |
| 55 |
430.8900 |
2026-07-25 00:00:00.0 |
7.8205 |
559 |
| 56 |
439.0092 |
2026-07-26 00:00:00.0 |
8.1192 |
559 |
| 57 |
446.9553 |
2026-07-27 00:00:00.0 |
7.9461 |
559 |
| 58 |
455.2791 |
2026-07-28 00:00:00.0 |
8.3238 |
559 |
| 59 |
462.9888 |
2026-07-29 00:00:00.0 |
7.7097 |
559 |
| 60 |
469.5509 |
2026-07-30 00:00:00.0 |
6.5621 |
559 |
| 61 |
478.3670 |
2026-07-31 00:00:00.0 |
8.8161 |
559 |
| 62 |
486.4664 |
2026-08-01 00:00:00.0 |
8.0994 |
559 |
| 63 |
495.4908 |
2026-08-02 00:00:00.0 |
9.0244 |
559 |
| 64 |
502.3850 |
2026-08-03 00:00:00.0 |
6.8942 |
559 |
| 65 |
510.9546 |
2026-08-04 00:00:00.0 |
8.5696 |
559 |
| 66 |
517.8098 |
2026-08-05 00:00:00.0 |
6.8552 |
559 |
| 67 |
525.0585 |
2026-08-06 00:00:00.0 |
7.2487 |
559 |
| 68 |
532.7285 |
2026-08-07 00:00:00.0 |
7.6700 |
559 |
| 69 |
539.8785 |
2026-08-08 00:00:00.0 |
7.1500 |
559 |
| 70 |
546.5891 |
2026-08-09 00:00:00.0 |
6.7106 |
559 |
| 71 |
552.6787 |
2026-08-10 00:00:00.0 |
6.0896 |
559 |
| 72 |
561.6784 |
2026-08-11 00:00:00.0 |
8.9997 |
559 |
| 73 |
568.9854 |
2026-08-12 00:00:00.0 |
7.3070 |
559 |
| 74 |
577.5029 |
2026-08-13 00:00:00.0 |
8.5175 |
559 |
| 75 |
585.9307 |
2026-08-14 00:00:00.0 |
8.4278 |
559 |
| 76 |
594.7498 |
2026-08-15 00:00:00.0 |
8.8191 |
559 |
| 77 |
603.5103 |
2026-08-16 00:00:00.0 |
8.7605 |
559 |
| 78 |
611.1597 |
2026-08-17 00:00:00.0 |
7.6494 |
559 |
| 79 |
618.5395 |
2026-08-18 00:00:00.0 |
7.3798 |
559 |
| 80 |
624.6696 |
2026-08-19 00:00:00.0 |
6.1301 |
559 |
| 81 |
631.1134 |
2026-08-20 00:00:00.0 |
6.4438 |
559 |
| 82 |
638.1296 |
2026-08-21 00:00:00.0 |
7.0162 |
559 |
|
| CACHED |
false |
| EXECUTIONTIME |
31 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '559') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-08-21'}
ORDER BY ddate ASC |
