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 |
|
CACHED |
false |
EXECUTIONTIME |
15 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '536') AND ddate BETWEEN {d '2025-06-01'} AND {d '2025-09-15'}
ORDER BY ddate ASC |