| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.1122 |
2025-06-01 00:00:00.0 |
7.1122 |
536 |
| 2 |
13.8467 |
2025-06-02 00:00:00.0 |
6.7345 |
536 |
| 3 |
21.9827 |
2025-06-03 00:00:00.0 |
8.1360 |
536 |
| 4 |
28.2932 |
2025-06-04 00:00:00.0 |
6.3105 |
536 |
| 5 |
34.0716 |
2025-06-05 00:00:00.0 |
5.7784 |
536 |
| 6 |
39.5935 |
2025-06-06 00:00:00.0 |
5.5219 |
536 |
| 7 |
45.9513 |
2025-06-07 00:00:00.0 |
6.3578 |
536 |
| 8 |
53.7592 |
2025-06-08 00:00:00.0 |
7.8079 |
536 |
| 9 |
58.0431 |
2025-06-09 00:00:00.0 |
4.2839 |
536 |
| 10 |
61.5162 |
2025-06-10 00:00:00.0 |
3.4731 |
536 |
| 11 |
67.5078 |
2025-06-11 00:00:00.0 |
5.9916 |
536 |
| 12 |
73.4911 |
2025-06-12 00:00:00.0 |
5.9833 |
536 |
| 13 |
80.5548 |
2025-06-13 00:00:00.0 |
7.0637 |
536 |
| 14 |
87.9721 |
2025-06-14 00:00:00.0 |
7.4173 |
536 |
| 15 |
94.5816 |
2025-06-15 00:00:00.0 |
6.6095 |
536 |
| 16 |
101.5661 |
2025-06-16 00:00:00.0 |
6.9845 |
536 |
| 17 |
110.0313 |
2025-06-17 00:00:00.0 |
8.4652 |
536 |
| 18 |
118.2723 |
2025-06-18 00:00:00.0 |
8.2410 |
536 |
| 19 |
126.1184 |
2025-06-19 00:00:00.0 |
7.8461 |
536 |
| 20 |
134.3558 |
2025-06-20 00:00:00.0 |
8.2374 |
536 |
| 21 |
142.9083 |
2025-06-21 00:00:00.0 |
8.5525 |
536 |
| 22 |
152.4459 |
2025-06-22 00:00:00.0 |
9.5376 |
536 |
| 23 |
160.7285 |
2025-06-23 00:00:00.0 |
8.2826 |
536 |
| 24 |
165.8040 |
2025-06-24 00:00:00.0 |
5.0755 |
536 |
| 25 |
170.9301 |
2025-06-25 00:00:00.0 |
5.1261 |
536 |
| 26 |
178.0526 |
2025-06-26 00:00:00.0 |
7.1225 |
536 |
| 27 |
186.5473 |
2025-06-27 00:00:00.0 |
8.4947 |
536 |
| 28 |
193.4256 |
2025-06-28 00:00:00.0 |
6.8783 |
536 |
| 29 |
200.8651 |
2025-06-29 00:00:00.0 |
7.4395 |
536 |
| 30 |
209.4799 |
2025-06-30 00:00:00.0 |
8.6148 |
536 |
| 31 |
218.3229 |
2025-07-01 00:00:00.0 |
8.8430 |
536 |
| 32 |
226.4598 |
2025-07-02 00:00:00.0 |
8.1369 |
536 |
| 33 |
235.2274 |
2025-07-03 00:00:00.0 |
8.7676 |
536 |
| 34 |
242.5840 |
2025-07-04 00:00:00.0 |
7.3566 |
536 |
| 35 |
250.0443 |
2025-07-05 00:00:00.0 |
7.4603 |
536 |
| 36 |
259.0901 |
2025-07-06 00:00:00.0 |
9.0458 |
536 |
| 37 |
266.7150 |
2025-07-07 00:00:00.0 |
7.6249 |
536 |
| 38 |
273.1758 |
2025-07-08 00:00:00.0 |
6.4608 |
536 |
| 39 |
280.4410 |
2025-07-09 00:00:00.0 |
7.2652 |
536 |
| 40 |
287.9411 |
2025-07-10 00:00:00.0 |
7.5001 |
536 |
| 41 |
287.9411 |
2025-07-11 00:00:00.0 |
0.0000 |
536 |
| 42 |
297.2284 |
2025-07-12 00:00:00.0 |
9.2873 |
536 |
| 43 |
305.9048 |
2025-07-13 00:00:00.0 |
8.6764 |
536 |
| 44 |
314.2047 |
2025-07-14 00:00:00.0 |
8.2999 |
536 |
| 45 |
322.7141 |
2025-07-15 00:00:00.0 |
8.5094 |
536 |
| 46 |
330.6839 |
2025-07-16 00:00:00.0 |
7.9698 |
536 |
| 47 |
338.0675 |
2025-07-17 00:00:00.0 |
7.3836 |
536 |
| 48 |
343.9112 |
2025-07-18 00:00:00.0 |
5.8437 |
536 |
| 49 |
350.5162 |
2025-07-19 00:00:00.0 |
6.6050 |
536 |
| 50 |
358.2006 |
2025-07-20 00:00:00.0 |
7.6844 |
536 |
| 51 |
366.6017 |
2025-07-21 00:00:00.0 |
8.4011 |
536 |
| 52 |
375.2379 |
2025-07-22 00:00:00.0 |
8.6362 |
536 |
| 53 |
384.2837 |
2025-07-23 00:00:00.0 |
9.0458 |
536 |
| 54 |
393.3800 |
2025-07-24 00:00:00.0 |
9.0963 |
536 |
| 55 |
402.2517 |
2025-07-25 00:00:00.0 |
8.8717 |
536 |
| 56 |
409.5864 |
2025-07-26 00:00:00.0 |
7.3347 |
536 |
| 57 |
417.9913 |
2025-07-27 00:00:00.0 |
8.4049 |
536 |
| 58 |
427.3836 |
2025-07-28 00:00:00.0 |
9.3923 |
536 |
| 59 |
435.7533 |
2025-07-29 00:00:00.0 |
8.3697 |
536 |
| 60 |
440.8856 |
2025-07-30 00:00:00.0 |
5.1323 |
536 |
| 61 |
448.4238 |
2025-07-31 00:00:00.0 |
7.5382 |
536 |
| 62 |
454.9281 |
2025-08-01 00:00:00.0 |
6.5043 |
536 |
| 63 |
461.4416 |
2025-08-02 00:00:00.0 |
6.5135 |
536 |
| 64 |
469.2797 |
2025-08-03 00:00:00.0 |
7.8381 |
536 |
| 65 |
477.0798 |
2025-08-04 00:00:00.0 |
7.8001 |
536 |
| 66 |
485.7961 |
2025-08-05 00:00:00.0 |
8.7163 |
536 |
| 67 |
494.7239 |
2025-08-06 00:00:00.0 |
8.9278 |
536 |
| 68 |
502.7759 |
2025-08-07 00:00:00.0 |
8.0520 |
536 |
| 69 |
510.9908 |
2025-08-08 00:00:00.0 |
8.2149 |
536 |
| 70 |
520.3708 |
2025-08-09 00:00:00.0 |
9.3800 |
536 |
| 71 |
529.2820 |
2025-08-10 00:00:00.0 |
8.9112 |
536 |
| 72 |
538.4606 |
2025-08-11 00:00:00.0 |
9.1786 |
536 |
| 73 |
547.7146 |
2025-08-12 00:00:00.0 |
9.2540 |
536 |
| 74 |
556.0542 |
2025-08-13 00:00:00.0 |
8.3396 |
536 |
| 75 |
562.4044 |
2025-08-14 00:00:00.0 |
6.3502 |
536 |
| 76 |
570.6566 |
2025-08-15 00:00:00.0 |
8.2522 |
536 |
| 77 |
577.4557 |
2025-08-16 00:00:00.0 |
6.7991 |
536 |
| 78 |
585.1761 |
2025-08-17 00:00:00.0 |
7.7204 |
536 |
| 79 |
593.2741 |
2025-08-18 00:00:00.0 |
8.0980 |
536 |
| 80 |
602.7766 |
2025-08-19 00:00:00.0 |
9.5025 |
536 |
| 81 |
611.6637 |
2025-08-20 00:00:00.0 |
8.8871 |
536 |
| 82 |
619.5948 |
2025-08-21 00:00:00.0 |
7.9311 |
536 |
| 83 |
628.6826 |
2025-08-22 00:00:00.0 |
9.0878 |
536 |
| 84 |
635.9453 |
2025-08-23 00:00:00.0 |
7.2627 |
536 |
| 85 |
643.6261 |
2025-08-24 00:00:00.0 |
7.6808 |
536 |
| 86 |
649.5557 |
2025-08-25 00:00:00.0 |
5.9296 |
536 |
| 87 |
655.4414 |
2025-08-26 00:00:00.0 |
5.8857 |
536 |
| 88 |
661.9880 |
2025-08-27 00:00:00.0 |
6.5466 |
536 |
| 89 |
670.7026 |
2025-08-28 00:00:00.0 |
8.7146 |
536 |
| 90 |
678.4392 |
2025-08-29 00:00:00.0 |
7.7366 |
536 |
| 91 |
685.8572 |
2025-08-30 00:00:00.0 |
7.4180 |
536 |
| 92 |
692.9868 |
2025-08-31 00:00:00.0 |
7.1296 |
536 |
| 93 |
700.3555 |
2025-09-01 00:00:00.0 |
7.3687 |
536 |
| 94 |
708.5559 |
2025-09-02 00:00:00.0 |
8.2004 |
536 |
| 95 |
714.0479 |
2025-09-03 00:00:00.0 |
5.4920 |
536 |
| 96 |
717.0127 |
2025-09-04 00:00:00.0 |
2.9648 |
536 |
| 97 |
717.2662 |
2025-09-05 00:00:00.0 |
0.2535 |
536 |
| 98 |
722.0162 |
2025-09-06 00:00:00.0 |
4.7500 |
536 |
| 99 |
725.0612 |
2025-09-07 00:00:00.0 |
3.0450 |
536 |
| 100 |
729.0627 |
2025-09-08 00:00:00.0 |
4.0015 |
536 |
| 101 |
735.6210 |
2025-09-09 00:00:00.0 |
6.5583 |
536 |
| 102 |
742.5110 |
2025-09-10 00:00:00.0 |
6.8900 |
536 |
| 103 |
749.8198 |
2025-09-11 00:00:00.0 |
7.3088 |
536 |
| 104 |
757.6547 |
2025-09-12 00:00:00.0 |
7.8349 |
536 |
| 105 |
767.0879 |
2025-09-13 00:00:00.0 |
9.4332 |
536 |
| 106 |
776.1053 |
2025-09-14 00:00:00.0 |
9.0174 |
536 |
| 107 |
785.7372 |
2025-09-15 00:00:00.0 |
9.6319 |
536 |
| 108 |
794.4062 |
2025-09-16 00:00:00.0 |
8.6690 |
536 |
| 109 |
803.6467 |
2025-09-17 00:00:00.0 |
9.2405 |
536 |
| 110 |
811.7989 |
2025-09-18 00:00:00.0 |
8.1522 |
536 |
| 111 |
819.4496 |
2025-09-19 00:00:00.0 |
7.6507 |
536 |
| 112 |
827.4955 |
2025-09-20 00:00:00.0 |
8.0459 |
536 |
| 113 |
836.1081 |
2025-09-21 00:00:00.0 |
8.6126 |
536 |
| 114 |
844.3375 |
2025-09-22 00:00:00.0 |
8.2294 |
536 |
| 115 |
852.4977 |
2025-09-23 00:00:00.0 |
8.1602 |
536 |
| 116 |
861.3459 |
2025-09-24 00:00:00.0 |
8.8482 |
536 |
| 117 |
868.1589 |
2025-09-25 00:00:00.0 |
6.8130 |
536 |
| 118 |
874.2756 |
2025-09-26 00:00:00.0 |
6.1167 |
536 |
| 119 |
879.9643 |
2025-09-27 00:00:00.0 |
5.6887 |
536 |
| 120 |
886.0958 |
2025-09-28 00:00:00.0 |
6.1315 |
536 |
| 121 |
892.0954 |
2025-09-29 00:00:00.0 |
5.9996 |
536 |
| 122 |
900.2154 |
2025-09-30 00:00:00.0 |
8.1200 |
536 |
| 123 |
907.6928 |
2025-10-01 00:00:00.0 |
7.4774 |
536 |
| 124 |
916.6478 |
2025-10-02 00:00:00.0 |
8.9550 |
536 |
| 125 |
924.2843 |
2025-10-03 00:00:00.0 |
7.6365 |
536 |
| 126 |
932.9343 |
2025-10-04 00:00:00.0 |
8.6500 |
536 |
| 127 |
941.1066 |
2025-10-05 00:00:00.0 |
8.1723 |
536 |
| 128 |
944.1995 |
2025-10-06 00:00:00.0 |
3.0929 |
536 |
| 129 |
945.1344 |
2025-10-07 00:00:00.0 |
0.9349 |
536 |
| 130 |
945.5844 |
2025-10-08 00:00:00.0 |
0.4500 |
536 |
| 131 |
948.5999 |
2025-10-09 00:00:00.0 |
3.0155 |
536 |
| 132 |
953.1735 |
2025-10-10 00:00:00.0 |
4.5736 |
536 |
| 133 |
956.4494 |
2025-10-11 00:00:00.0 |
3.2759 |
536 |
| 134 |
960.0784 |
2025-10-12 00:00:00.0 |
3.6290 |
536 |
| 135 |
964.7455 |
2025-10-13 00:00:00.0 |
4.6671 |
536 |
| 136 |
964.9990 |
2025-10-14 00:00:00.0 |
0.2535 |
536 |
| 137 |
964.9990 |
2025-10-15 00:00:00.0 |
0.0000 |
536 |
| 138 |
966.5267 |
2025-10-16 00:00:00.0 |
1.5277 |
536 |
| 139 |
969.2478 |
2025-10-17 00:00:00.0 |
2.7211 |
536 |
| 140 |
972.7573 |
2025-10-18 00:00:00.0 |
3.5095 |
536 |
| 141 |
973.6621 |
2025-10-19 00:00:00.0 |
0.9048 |
536 |
| 142 |
974.8929 |
2025-10-20 00:00:00.0 |
1.2308 |
536 |
| 143 |
974.9978 |
2025-10-21 00:00:00.0 |
0.1049 |
536 |
| 144 |
974.9978 |
2025-10-22 00:00:00.0 |
0.0000 |
536 |
| 145 |
974.9978 |
2025-10-23 00:00:00.0 |
0.0000 |
536 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '536') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-10-23'}
ORDER BY ddate ASC |