query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
7.6312 |
2025-06-01 00:00:00.0 |
7.6312 |
314 |
2 |
14.7821 |
2025-06-02 00:00:00.0 |
7.1509 |
314 |
3 |
22.3436 |
2025-06-03 00:00:00.0 |
7.5615 |
314 |
4 |
28.0596 |
2025-06-04 00:00:00.0 |
5.7160 |
314 |
5 |
33.3388 |
2025-06-05 00:00:00.0 |
5.2792 |
314 |
6 |
38.5597 |
2025-06-06 00:00:00.0 |
5.2209 |
314 |
7 |
45.4490 |
2025-06-07 00:00:00.0 |
6.8893 |
314 |
8 |
52.7558 |
2025-06-08 00:00:00.0 |
7.3068 |
314 |
9 |
55.7987 |
2025-06-09 00:00:00.0 |
3.0429 |
314 |
10 |
61.9497 |
2025-06-10 00:00:00.0 |
6.1510 |
314 |
11 |
69.5863 |
2025-06-11 00:00:00.0 |
7.6366 |
314 |
12 |
75.6057 |
2025-06-12 00:00:00.0 |
6.0194 |
314 |
13 |
81.5348 |
2025-06-13 00:00:00.0 |
5.9291 |
314 |
14 |
87.9872 |
2025-06-14 00:00:00.0 |
6.4524 |
314 |
15 |
94.5631 |
2025-06-15 00:00:00.0 |
6.5759 |
314 |
16 |
102.7069 |
2025-06-16 00:00:00.0 |
8.1438 |
314 |
17 |
111.7734 |
2025-06-17 00:00:00.0 |
9.0665 |
314 |
18 |
119.6243 |
2025-06-18 00:00:00.0 |
7.8509 |
314 |
19 |
128.0673 |
2025-06-19 00:00:00.0 |
8.4430 |
314 |
20 |
136.1067 |
2025-06-20 00:00:00.0 |
8.0394 |
314 |
21 |
144.7056 |
2025-06-21 00:00:00.0 |
8.5989 |
314 |
22 |
153.9307 |
2025-06-22 00:00:00.0 |
9.2251 |
314 |
23 |
160.4151 |
2025-06-23 00:00:00.0 |
6.4844 |
314 |
24 |
164.3954 |
2025-06-24 00:00:00.0 |
3.9803 |
314 |
25 |
170.2641 |
2025-06-25 00:00:00.0 |
5.8687 |
314 |
26 |
176.4010 |
2025-06-26 00:00:00.0 |
6.1369 |
314 |
27 |
184.6931 |
2025-06-27 00:00:00.0 |
8.2921 |
314 |
28 |
192.5617 |
2025-06-28 00:00:00.0 |
7.8686 |
314 |
29 |
200.3930 |
2025-06-29 00:00:00.0 |
7.8313 |
314 |
30 |
209.5813 |
2025-06-30 00:00:00.0 |
9.1883 |
314 |
31 |
218.6650 |
2025-07-01 00:00:00.0 |
9.0837 |
314 |
32 |
226.8734 |
2025-07-02 00:00:00.0 |
8.2084 |
314 |
33 |
235.3844 |
2025-07-03 00:00:00.0 |
8.5110 |
314 |
34 |
242.8033 |
2025-07-04 00:00:00.0 |
7.4189 |
314 |
35 |
251.1207 |
2025-07-05 00:00:00.0 |
8.3174 |
314 |
36 |
259.1106 |
2025-07-06 00:00:00.0 |
7.9899 |
314 |
37 |
264.9761 |
2025-07-07 00:00:00.0 |
5.8655 |
314 |
38 |
264.9761 |
2025-07-08 00:00:00.0 |
0.0000 |
314 |
39 |
271.4198 |
2025-07-09 00:00:00.0 |
6.4437 |
314 |
40 |
279.6640 |
2025-07-10 00:00:00.0 |
8.2442 |
314 |
41 |
288.3518 |
2025-07-11 00:00:00.0 |
8.6878 |
314 |
42 |
296.7809 |
2025-07-12 00:00:00.0 |
8.4291 |
314 |
43 |
304.7591 |
2025-07-13 00:00:00.0 |
7.9782 |
314 |
44 |
313.3529 |
2025-07-14 00:00:00.0 |
8.5938 |
314 |
45 |
321.2013 |
2025-07-15 00:00:00.0 |
7.8484 |
314 |
46 |
327.6530 |
2025-07-16 00:00:00.0 |
6.4517 |
314 |
47 |
333.4868 |
2025-07-17 00:00:00.0 |
5.8338 |
314 |
48 |
338.7549 |
2025-07-18 00:00:00.0 |
5.2681 |
314 |
49 |
345.1706 |
2025-07-19 00:00:00.0 |
6.4157 |
314 |
50 |
351.4396 |
2025-07-20 00:00:00.0 |
6.2690 |
314 |
51 |
360.2124 |
2025-07-21 00:00:00.0 |
8.7728 |
314 |
52 |
369.1130 |
2025-07-22 00:00:00.0 |
8.9006 |
314 |
53 |
377.9108 |
2025-07-23 00:00:00.0 |
8.7978 |
314 |
54 |
386.8031 |
2025-07-24 00:00:00.0 |
8.8923 |
314 |
55 |
395.9939 |
2025-07-25 00:00:00.0 |
9.1908 |
314 |
56 |
403.7093 |
2025-07-26 00:00:00.0 |
7.7154 |
314 |
57 |
412.2839 |
2025-07-27 00:00:00.0 |
8.5746 |
314 |
58 |
421.3756 |
2025-07-28 00:00:00.0 |
9.0917 |
314 |
59 |
429.5135 |
2025-07-29 00:00:00.0 |
8.1379 |
314 |
60 |
437.1163 |
2025-07-30 00:00:00.0 |
7.6028 |
314 |
61 |
443.7347 |
2025-07-31 00:00:00.0 |
6.6184 |
314 |
62 |
450.0476 |
2025-08-01 00:00:00.0 |
6.3129 |
314 |
63 |
457.2196 |
2025-08-02 00:00:00.0 |
7.1720 |
314 |
64 |
465.6357 |
2025-08-03 00:00:00.0 |
8.4161 |
314 |
65 |
474.0829 |
2025-08-04 00:00:00.0 |
8.4472 |
314 |
66 |
482.0275 |
2025-08-05 00:00:00.0 |
7.9446 |
314 |
67 |
491.4725 |
2025-08-06 00:00:00.0 |
9.4450 |
314 |
68 |
500.5094 |
2025-08-07 00:00:00.0 |
9.0369 |
314 |
69 |
508.4663 |
2025-08-08 00:00:00.0 |
7.9569 |
314 |
70 |
518.2097 |
2025-08-09 00:00:00.0 |
9.7434 |
314 |
71 |
526.1218 |
2025-08-10 00:00:00.0 |
7.9121 |
314 |
72 |
534.8534 |
2025-08-11 00:00:00.0 |
8.7316 |
314 |
73 |
543.7341 |
2025-08-12 00:00:00.0 |
8.8807 |
314 |
74 |
551.2511 |
2025-08-13 00:00:00.0 |
7.5170 |
314 |
75 |
558.0621 |
2025-08-14 00:00:00.0 |
6.8110 |
314 |
76 |
566.7628 |
2025-08-15 00:00:00.0 |
8.7007 |
314 |
77 |
573.6942 |
2025-08-16 00:00:00.0 |
6.9314 |
314 |
78 |
580.2765 |
2025-08-17 00:00:00.0 |
6.5823 |
314 |
79 |
587.5988 |
2025-08-18 00:00:00.0 |
7.3223 |
314 |
80 |
596.7881 |
2025-08-19 00:00:00.0 |
9.1893 |
314 |
81 |
605.9759 |
2025-08-20 00:00:00.0 |
9.1878 |
314 |
82 |
613.7429 |
2025-08-21 00:00:00.0 |
7.7670 |
314 |
83 |
622.1994 |
2025-08-22 00:00:00.0 |
8.4565 |
314 |
84 |
628.7195 |
2025-08-23 00:00:00.0 |
6.5201 |
314 |
85 |
634.8731 |
2025-08-24 00:00:00.0 |
6.1536 |
314 |
86 |
640.0814 |
2025-08-25 00:00:00.0 |
5.2083 |
314 |
87 |
646.1360 |
2025-08-26 00:00:00.0 |
6.0546 |
314 |
88 |
653.3211 |
2025-08-27 00:00:00.0 |
7.1851 |
314 |
89 |
661.2838 |
2025-08-28 00:00:00.0 |
7.9627 |
314 |
90 |
668.7382 |
2025-08-29 00:00:00.0 |
7.4544 |
314 |
91 |
676.0872 |
2025-08-30 00:00:00.0 |
7.3490 |
314 |
92 |
683.2308 |
2025-08-31 00:00:00.0 |
7.1436 |
314 |
93 |
691.0276 |
2025-09-01 00:00:00.0 |
7.7968 |
314 |
94 |
699.4467 |
2025-09-02 00:00:00.0 |
8.4191 |
314 |
95 |
704.7781 |
2025-09-03 00:00:00.0 |
5.3314 |
314 |
96 |
706.6144 |
2025-09-04 00:00:00.0 |
1.8363 |
314 |
97 |
706.9152 |
2025-09-05 00:00:00.0 |
0.3008 |
314 |
98 |
709.9090 |
2025-09-06 00:00:00.0 |
2.9938 |
314 |
99 |
712.0439 |
2025-09-07 00:00:00.0 |
2.1349 |
314 |
100 |
715.7374 |
2025-09-08 00:00:00.0 |
3.6935 |
314 |
101 |
722.0148 |
2025-09-09 00:00:00.0 |
6.2774 |
314 |
102 |
729.4113 |
2025-09-10 00:00:00.0 |
7.3965 |
314 |
103 |
736.9494 |
2025-09-11 00:00:00.0 |
7.5381 |
314 |
104 |
745.6645 |
2025-09-12 00:00:00.0 |
8.7151 |
314 |
105 |
754.6370 |
2025-09-13 00:00:00.0 |
8.9725 |
314 |
106 |
763.8317 |
2025-09-14 00:00:00.0 |
9.1947 |
314 |
107 |
773.4700 |
2025-09-15 00:00:00.0 |
9.6383 |
314 |
108 |
783.0393 |
2025-09-16 00:00:00.0 |
9.5693 |
314 |
|
CACHED |
false |
EXECUTIONTIME |
31 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '314') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-16'}
ORDER BY ddate ASC |