| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
6.7974 |
2025-06-01 00:00:00.0 |
6.7974 |
203 |
| 2 |
13.9595 |
2025-06-02 00:00:00.0 |
7.1621 |
203 |
| 3 |
22.3637 |
2025-06-03 00:00:00.0 |
8.4042 |
203 |
| 4 |
29.2570 |
2025-06-04 00:00:00.0 |
6.8933 |
203 |
| 5 |
36.0500 |
2025-06-05 00:00:00.0 |
6.7930 |
203 |
| 6 |
41.4742 |
2025-06-06 00:00:00.0 |
5.4242 |
203 |
| 7 |
47.8240 |
2025-06-07 00:00:00.0 |
6.3498 |
203 |
| 8 |
55.9997 |
2025-06-08 00:00:00.0 |
8.1757 |
203 |
| 9 |
61.1574 |
2025-06-09 00:00:00.0 |
5.1577 |
203 |
| 10 |
65.0094 |
2025-06-10 00:00:00.0 |
3.8520 |
203 |
| 11 |
71.7665 |
2025-06-11 00:00:00.0 |
6.7571 |
203 |
| 12 |
78.3957 |
2025-06-12 00:00:00.0 |
6.6292 |
203 |
| 13 |
85.2480 |
2025-06-13 00:00:00.0 |
6.8523 |
203 |
| 14 |
92.1456 |
2025-06-14 00:00:00.0 |
6.8976 |
203 |
| 15 |
99.7522 |
2025-06-15 00:00:00.0 |
7.6066 |
203 |
| 16 |
107.8968 |
2025-06-16 00:00:00.0 |
8.1446 |
203 |
| 17 |
117.2473 |
2025-06-17 00:00:00.0 |
9.3505 |
203 |
| 18 |
125.2486 |
2025-06-18 00:00:00.0 |
8.0013 |
203 |
| 19 |
133.1282 |
2025-06-19 00:00:00.0 |
7.8796 |
203 |
| 20 |
141.3907 |
2025-06-20 00:00:00.0 |
8.2625 |
203 |
| 21 |
149.5513 |
2025-06-21 00:00:00.0 |
8.1606 |
203 |
| 22 |
158.0186 |
2025-06-22 00:00:00.0 |
8.4673 |
203 |
| 23 |
166.7789 |
2025-06-23 00:00:00.0 |
8.7603 |
203 |
| 24 |
172.9892 |
2025-06-24 00:00:00.0 |
6.2103 |
203 |
| 25 |
178.5629 |
2025-06-25 00:00:00.0 |
5.5737 |
203 |
| 26 |
186.3680 |
2025-06-26 00:00:00.0 |
7.8051 |
203 |
| 27 |
194.9331 |
2025-06-27 00:00:00.0 |
8.5651 |
203 |
| 28 |
202.6004 |
2025-06-28 00:00:00.0 |
7.6673 |
203 |
| 29 |
210.2987 |
2025-06-29 00:00:00.0 |
7.6983 |
203 |
| 30 |
219.0516 |
2025-06-30 00:00:00.0 |
8.7529 |
203 |
| 31 |
228.0164 |
2025-07-01 00:00:00.0 |
8.9648 |
203 |
| 32 |
235.9191 |
2025-07-02 00:00:00.0 |
7.9027 |
203 |
| 33 |
244.4638 |
2025-07-03 00:00:00.0 |
8.5447 |
203 |
| 34 |
251.7904 |
2025-07-04 00:00:00.0 |
7.3266 |
203 |
| 35 |
259.0599 |
2025-07-05 00:00:00.0 |
7.2695 |
203 |
| 36 |
267.3354 |
2025-07-06 00:00:00.0 |
8.2755 |
203 |
| 37 |
274.7897 |
2025-07-07 00:00:00.0 |
7.4543 |
203 |
| 38 |
282.6944 |
2025-07-08 00:00:00.0 |
7.9047 |
203 |
| 39 |
290.4013 |
2025-07-09 00:00:00.0 |
7.7069 |
203 |
| 40 |
298.3681 |
2025-07-10 00:00:00.0 |
7.9668 |
203 |
| 41 |
305.4517 |
2025-07-11 00:00:00.0 |
7.0836 |
203 |
| 42 |
314.8819 |
2025-07-12 00:00:00.0 |
9.4302 |
203 |
| 43 |
323.0976 |
2025-07-13 00:00:00.0 |
8.2157 |
203 |
| 44 |
331.9289 |
2025-07-14 00:00:00.0 |
8.8313 |
203 |
| 45 |
339.8996 |
2025-07-15 00:00:00.0 |
7.9707 |
203 |
| 46 |
347.0675 |
2025-07-16 00:00:00.0 |
7.1679 |
203 |
| 47 |
352.3254 |
2025-07-17 00:00:00.0 |
5.2579 |
203 |
| 48 |
358.1691 |
2025-07-18 00:00:00.0 |
5.8437 |
203 |
| 49 |
365.9293 |
2025-07-19 00:00:00.0 |
7.7602 |
203 |
| 50 |
373.4946 |
2025-07-20 00:00:00.0 |
7.5653 |
203 |
| 51 |
381.5304 |
2025-07-21 00:00:00.0 |
8.0358 |
203 |
| 52 |
390.3646 |
2025-07-22 00:00:00.0 |
8.8342 |
203 |
| 53 |
399.9049 |
2025-07-23 00:00:00.0 |
9.5403 |
203 |
| 54 |
409.0079 |
2025-07-24 00:00:00.0 |
9.1030 |
203 |
| 55 |
417.6516 |
2025-07-25 00:00:00.0 |
8.6437 |
203 |
| 56 |
425.3037 |
2025-07-26 00:00:00.0 |
7.6521 |
203 |
| 57 |
433.2644 |
2025-07-27 00:00:00.0 |
7.9607 |
203 |
| 58 |
442.8341 |
2025-07-28 00:00:00.0 |
9.5697 |
203 |
| 59 |
451.3921 |
2025-07-29 00:00:00.0 |
8.5580 |
203 |
| 60 |
459.8373 |
2025-07-30 00:00:00.0 |
8.4452 |
203 |
| 61 |
466.4151 |
2025-07-31 00:00:00.0 |
6.5778 |
203 |
| 62 |
473.2596 |
2025-08-01 00:00:00.0 |
6.8445 |
203 |
| 63 |
481.0027 |
2025-08-02 00:00:00.0 |
7.7431 |
203 |
| 64 |
489.9351 |
2025-08-03 00:00:00.0 |
8.9324 |
203 |
| 65 |
497.9459 |
2025-08-04 00:00:00.0 |
8.0108 |
203 |
| 66 |
506.6821 |
2025-08-05 00:00:00.0 |
8.7362 |
203 |
| 67 |
515.7762 |
2025-08-06 00:00:00.0 |
9.0941 |
203 |
| 68 |
524.0536 |
2025-08-07 00:00:00.0 |
8.2774 |
203 |
| 69 |
531.5731 |
2025-08-08 00:00:00.0 |
7.5195 |
203 |
| 70 |
540.5065 |
2025-08-09 00:00:00.0 |
8.9334 |
203 |
| 71 |
549.3631 |
2025-08-10 00:00:00.0 |
8.8566 |
203 |
| 72 |
558.4397 |
2025-08-11 00:00:00.0 |
9.0766 |
203 |
| 73 |
567.6537 |
2025-08-12 00:00:00.0 |
9.2140 |
203 |
| 74 |
576.4100 |
2025-08-13 00:00:00.0 |
8.7563 |
203 |
| 75 |
582.6908 |
2025-08-14 00:00:00.0 |
6.2808 |
203 |
| 76 |
590.3629 |
2025-08-15 00:00:00.0 |
7.6721 |
203 |
| 77 |
598.2598 |
2025-08-16 00:00:00.0 |
7.8969 |
203 |
| 78 |
606.5330 |
2025-08-17 00:00:00.0 |
8.2732 |
203 |
| 79 |
615.0197 |
2025-08-18 00:00:00.0 |
8.4867 |
203 |
| 80 |
624.6409 |
2025-08-19 00:00:00.0 |
9.6212 |
203 |
| 81 |
633.8373 |
2025-08-20 00:00:00.0 |
9.1964 |
203 |
| 82 |
641.6536 |
2025-08-21 00:00:00.0 |
7.8163 |
203 |
| 83 |
650.7639 |
2025-08-22 00:00:00.0 |
9.1103 |
203 |
| 84 |
658.5192 |
2025-08-23 00:00:00.0 |
7.7553 |
203 |
| 85 |
666.1884 |
2025-08-24 00:00:00.0 |
7.6692 |
203 |
| 86 |
671.9733 |
2025-08-25 00:00:00.0 |
5.7849 |
203 |
| 87 |
677.1457 |
2025-08-26 00:00:00.0 |
5.1724 |
203 |
| 88 |
684.8671 |
2025-08-27 00:00:00.0 |
7.7214 |
203 |
| 89 |
693.6025 |
2025-08-28 00:00:00.0 |
8.7354 |
203 |
| 90 |
701.1069 |
2025-08-29 00:00:00.0 |
7.5044 |
203 |
| 91 |
708.8178 |
2025-08-30 00:00:00.0 |
7.7109 |
203 |
| 92 |
716.0670 |
2025-08-31 00:00:00.0 |
7.2492 |
203 |
| 93 |
723.6172 |
2025-09-01 00:00:00.0 |
7.5502 |
203 |
| 94 |
731.6473 |
2025-09-02 00:00:00.0 |
8.0301 |
203 |
| 95 |
736.8305 |
2025-09-03 00:00:00.0 |
5.1832 |
203 |
| 96 |
739.0996 |
2025-09-04 00:00:00.0 |
2.2691 |
203 |
| 97 |
739.3371 |
2025-09-05 00:00:00.0 |
0.2375 |
203 |
| 98 |
742.8426 |
2025-09-06 00:00:00.0 |
3.5055 |
203 |
| 99 |
746.1886 |
2025-09-07 00:00:00.0 |
3.3460 |
203 |
| 100 |
749.7614 |
2025-09-08 00:00:00.0 |
3.5728 |
203 |
| 101 |
757.6252 |
2025-09-09 00:00:00.0 |
7.8638 |
203 |
| 102 |
764.4519 |
2025-09-10 00:00:00.0 |
6.8267 |
203 |
| 103 |
771.5005 |
2025-09-11 00:00:00.0 |
7.0486 |
203 |
| 104 |
780.1792 |
2025-09-12 00:00:00.0 |
8.6787 |
203 |
| 105 |
789.4478 |
2025-09-13 00:00:00.0 |
9.2686 |
203 |
| 106 |
798.6417 |
2025-09-14 00:00:00.0 |
9.1939 |
203 |
| 107 |
808.2672 |
2025-09-15 00:00:00.0 |
9.6255 |
203 |
| 108 |
817.0676 |
2025-09-16 00:00:00.0 |
8.8004 |
203 |
| 109 |
826.1074 |
2025-09-17 00:00:00.0 |
9.0398 |
203 |
| 110 |
833.8872 |
2025-09-18 00:00:00.0 |
7.7798 |
203 |
| 111 |
842.1572 |
2025-09-19 00:00:00.0 |
8.2700 |
203 |
| 112 |
850.4969 |
2025-09-20 00:00:00.0 |
8.3397 |
203 |
| 113 |
859.4977 |
2025-09-21 00:00:00.0 |
9.0008 |
203 |
| 114 |
868.0107 |
2025-09-22 00:00:00.0 |
8.5130 |
203 |
| 115 |
875.9943 |
2025-09-23 00:00:00.0 |
7.9836 |
203 |
| 116 |
883.8689 |
2025-09-24 00:00:00.0 |
7.8746 |
203 |
| 117 |
891.2884 |
2025-09-25 00:00:00.0 |
7.4195 |
203 |
| 118 |
896.1440 |
2025-09-26 00:00:00.0 |
4.8556 |
203 |
| 119 |
901.5408 |
2025-09-27 00:00:00.0 |
5.3968 |
203 |
| 120 |
908.6189 |
2025-09-28 00:00:00.0 |
7.0781 |
203 |
| 121 |
916.3571 |
2025-09-29 00:00:00.0 |
7.7382 |
203 |
| 122 |
923.7095 |
2025-09-30 00:00:00.0 |
7.3524 |
203 |
| 123 |
931.3937 |
2025-10-01 00:00:00.0 |
7.6842 |
203 |
| 124 |
940.4519 |
2025-10-02 00:00:00.0 |
9.0582 |
203 |
| 125 |
948.6159 |
2025-10-03 00:00:00.0 |
8.1640 |
203 |
| 126 |
956.9007 |
2025-10-04 00:00:00.0 |
8.2848 |
203 |
| 127 |
965.3793 |
2025-10-05 00:00:00.0 |
8.4786 |
203 |
| 128 |
968.3503 |
2025-10-06 00:00:00.0 |
2.9710 |
203 |
| 129 |
969.5617 |
2025-10-07 00:00:00.0 |
1.2114 |
203 |
| 130 |
969.9974 |
2025-10-08 00:00:00.0 |
0.4357 |
203 |
| 131 |
974.2300 |
2025-10-09 00:00:00.0 |
4.2326 |
203 |
| 132 |
979.1662 |
2025-10-10 00:00:00.0 |
4.9362 |
203 |
| 133 |
982.1921 |
2025-10-11 00:00:00.0 |
3.0259 |
203 |
| 134 |
987.7572 |
2025-10-12 00:00:00.0 |
5.5651 |
203 |
| 135 |
992.9704 |
2025-10-13 00:00:00.0 |
5.2132 |
203 |
| 136 |
993.3173 |
2025-10-14 00:00:00.0 |
0.3469 |
203 |
| 137 |
993.3173 |
2025-10-15 00:00:00.0 |
0.0000 |
203 |
| 138 |
995.2684 |
2025-10-16 00:00:00.0 |
1.9511 |
203 |
| 139 |
999.0976 |
2025-10-17 00:00:00.0 |
3.8292 |
203 |
| 140 |
1004.6943 |
2025-10-18 00:00:00.0 |
5.5967 |
203 |
| 141 |
1006.2923 |
2025-10-19 00:00:00.0 |
1.5980 |
203 |
| 142 |
1007.6618 |
2025-10-20 00:00:00.0 |
1.3695 |
203 |
| 143 |
1007.8993 |
2025-10-21 00:00:00.0 |
0.2375 |
203 |
| 144 |
1008.0212 |
2025-10-22 00:00:00.0 |
0.1219 |
203 |
| 145 |
1008.0212 |
2025-10-23 00:00:00.0 |
0.0000 |
203 |
| 146 |
1008.2906 |
2025-10-24 00:00:00.0 |
0.2694 |
203 |
| 147 |
1009.4038 |
2025-10-25 00:00:00.0 |
1.1132 |
203 |
| 148 |
1012.6706 |
2025-10-26 00:00:00.0 |
3.2668 |
203 |
| 149 |
1019.4589 |
2025-10-27 00:00:00.0 |
6.7883 |
203 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '203') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-10-27'}
ORDER BY ddate ASC |