| query |
| RESULTSET |
| query |
| |
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
| 1 |
7.8272 |
2026-06-01 00:00:00.0 |
7.8272 |
243 |
| 2 |
16.5863 |
2026-06-02 00:00:00.0 |
8.7591 |
243 |
| 3 |
24.7488 |
2026-06-03 00:00:00.0 |
8.1625 |
243 |
| 4 |
34.2989 |
2026-06-04 00:00:00.0 |
9.5501 |
243 |
| 5 |
43.1955 |
2026-06-05 00:00:00.0 |
8.8966 |
243 |
| 6 |
51.0337 |
2026-06-06 00:00:00.0 |
7.8382 |
243 |
| 7 |
58.0782 |
2026-06-07 00:00:00.0 |
7.0445 |
243 |
| 8 |
62.9645 |
2026-06-08 00:00:00.0 |
4.8863 |
243 |
| 9 |
71.5961 |
2026-06-09 00:00:00.0 |
8.6316 |
243 |
| 10 |
78.6710 |
2026-06-10 00:00:00.0 |
7.0749 |
243 |
| 11 |
88.0916 |
2026-06-11 00:00:00.0 |
9.4206 |
243 |
| 12 |
96.7727 |
2026-06-12 00:00:00.0 |
8.6811 |
243 |
| 13 |
103.9009 |
2026-06-13 00:00:00.0 |
7.1282 |
243 |
| 14 |
108.6437 |
2026-06-14 00:00:00.0 |
4.7428 |
243 |
| 15 |
114.6438 |
2026-06-15 00:00:00.0 |
6.0001 |
243 |
| 16 |
121.1450 |
2026-06-16 00:00:00.0 |
6.5012 |
243 |
| 17 |
127.3271 |
2026-06-17 00:00:00.0 |
6.1821 |
243 |
| 18 |
134.9947 |
2026-06-18 00:00:00.0 |
7.6676 |
243 |
| 19 |
140.4786 |
2026-06-19 00:00:00.0 |
5.4839 |
243 |
| 20 |
148.4495 |
2026-06-20 00:00:00.0 |
7.9709 |
243 |
| 21 |
154.9768 |
2026-06-21 00:00:00.0 |
6.5273 |
243 |
| 22 |
160.5407 |
2026-06-22 00:00:00.0 |
5.5639 |
243 |
| 23 |
168.7888 |
2026-06-23 00:00:00.0 |
8.2481 |
243 |
| 24 |
176.8667 |
2026-06-24 00:00:00.0 |
8.0779 |
243 |
| 25 |
185.6933 |
2026-06-25 00:00:00.0 |
8.8266 |
243 |
| 26 |
193.5256 |
2026-06-26 00:00:00.0 |
7.8323 |
243 |
| 27 |
201.7758 |
2026-06-27 00:00:00.0 |
8.2502 |
243 |
| 28 |
211.1227 |
2026-06-28 00:00:00.0 |
9.3469 |
243 |
| 29 |
220.3169 |
2026-06-29 00:00:00.0 |
9.1942 |
243 |
| 30 |
229.4814 |
2026-06-30 00:00:00.0 |
9.1645 |
243 |
| 31 |
238.6661 |
2026-07-01 00:00:00.0 |
9.1847 |
243 |
| 32 |
248.0174 |
2026-07-02 00:00:00.0 |
9.3513 |
243 |
| 33 |
256.8844 |
2026-07-03 00:00:00.0 |
8.8670 |
243 |
| 34 |
266.0296 |
2026-07-04 00:00:00.0 |
9.1452 |
243 |
| 35 |
274.6177 |
2026-07-05 00:00:00.0 |
8.5881 |
243 |
| 36 |
281.6025 |
2026-07-06 00:00:00.0 |
6.9848 |
243 |
| 37 |
290.3335 |
2026-07-07 00:00:00.0 |
8.7310 |
243 |
| 38 |
299.3237 |
2026-07-08 00:00:00.0 |
8.9902 |
243 |
| 39 |
307.6385 |
2026-07-09 00:00:00.0 |
8.3148 |
243 |
| 40 |
316.1033 |
2026-07-10 00:00:00.0 |
8.4648 |
243 |
| 41 |
323.7366 |
2026-07-11 00:00:00.0 |
7.6333 |
243 |
| 42 |
329.7445 |
2026-07-12 00:00:00.0 |
6.0079 |
243 |
| 43 |
333.7348 |
2026-07-13 00:00:00.0 |
3.9903 |
243 |
| 44 |
338.1373 |
2026-07-14 00:00:00.0 |
4.4025 |
243 |
| 45 |
346.7952 |
2026-07-15 00:00:00.0 |
8.6579 |
243 |
| 46 |
356.6557 |
2026-07-16 00:00:00.0 |
9.8605 |
243 |
| 47 |
366.2534 |
2026-07-17 00:00:00.0 |
9.5977 |
243 |
| 48 |
375.5159 |
2026-07-18 00:00:00.0 |
9.2625 |
243 |
| 49 |
383.1312 |
2026-07-19 00:00:00.0 |
7.6153 |
243 |
| 50 |
390.0799 |
2026-07-20 00:00:00.0 |
6.9487 |
243 |
| 51 |
399.2855 |
2026-07-21 00:00:00.0 |
9.2056 |
243 |
| 52 |
407.2389 |
2026-07-22 00:00:00.0 |
7.9534 |
243 |
| 53 |
414.8145 |
2026-07-23 00:00:00.0 |
7.5756 |
243 |
| 54 |
423.2233 |
2026-07-24 00:00:00.0 |
8.4088 |
243 |
| 55 |
431.4112 |
2026-07-25 00:00:00.0 |
8.1879 |
243 |
| 56 |
439.4673 |
2026-07-26 00:00:00.0 |
8.0561 |
243 |
| 57 |
447.9937 |
2026-07-27 00:00:00.0 |
8.5264 |
243 |
| 58 |
456.1926 |
2026-07-28 00:00:00.0 |
8.1989 |
243 |
| 59 |
463.8128 |
2026-07-29 00:00:00.0 |
7.6202 |
243 |
| 60 |
469.3027 |
2026-07-30 00:00:00.0 |
5.4899 |
243 |
| 61 |
476.7145 |
2026-07-31 00:00:00.0 |
7.4118 |
243 |
| 62 |
485.0153 |
2026-08-01 00:00:00.0 |
8.3008 |
243 |
| 63 |
493.5583 |
2026-08-02 00:00:00.0 |
8.5430 |
243 |
| 64 |
500.7315 |
2026-08-03 00:00:00.0 |
7.1732 |
243 |
| 65 |
509.4071 |
2026-08-04 00:00:00.0 |
8.6756 |
243 |
| 66 |
516.4894 |
2026-08-05 00:00:00.0 |
7.0823 |
243 |
| 67 |
523.2386 |
2026-08-06 00:00:00.0 |
6.7492 |
243 |
| 68 |
530.8785 |
2026-08-07 00:00:00.0 |
7.6399 |
243 |
| 69 |
538.5991 |
2026-08-08 00:00:00.0 |
7.7206 |
243 |
| 70 |
544.7744 |
2026-08-09 00:00:00.0 |
6.1753 |
243 |
| 71 |
550.9943 |
2026-08-10 00:00:00.0 |
6.2199 |
243 |
| 72 |
558.5587 |
2026-08-11 00:00:00.0 |
7.5644 |
243 |
| 73 |
566.0701 |
2026-08-12 00:00:00.0 |
7.5114 |
243 |
| 74 |
574.5143 |
2026-08-13 00:00:00.0 |
8.4442 |
243 |
| 75 |
582.5584 |
2026-08-14 00:00:00.0 |
8.0441 |
243 |
| 76 |
591.3369 |
2026-08-15 00:00:00.0 |
8.7785 |
243 |
| 77 |
600.9220 |
2026-08-16 00:00:00.0 |
9.5851 |
243 |
|
| CACHED |
false |
| EXECUTIONTIME |
0 |
| SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '243') AND ddate BETWEEN {d '2026-06-01'} AND {d '2026-08-16'}
ORDER BY ddate ASC |
