query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
47.0640 |
2024-06-06 00:00:00.0 |
5.1038 |
243 |
2 |
53.2713 |
2024-06-07 00:00:00.0 |
6.2073 |
243 |
3 |
59.5961 |
2024-06-08 00:00:00.0 |
6.3248 |
243 |
4 |
65.5952 |
2024-06-09 00:00:00.0 |
5.9991 |
243 |
5 |
71.6591 |
2024-06-10 00:00:00.0 |
6.0639 |
243 |
6 |
80.4061 |
2024-06-11 00:00:00.0 |
8.7470 |
243 |
7 |
88.9630 |
2024-06-12 00:00:00.0 |
8.5569 |
243 |
8 |
96.5500 |
2024-06-13 00:00:00.0 |
7.5870 |
243 |
9 |
104.0029 |
2024-06-14 00:00:00.0 |
7.4529 |
243 |
10 |
112.1383 |
2024-06-15 00:00:00.0 |
8.1354 |
243 |
11 |
120.9999 |
2024-06-16 00:00:00.0 |
8.8616 |
243 |
12 |
127.7095 |
2024-06-17 00:00:00.0 |
6.7096 |
243 |
13 |
134.2748 |
2024-06-18 00:00:00.0 |
6.5653 |
243 |
14 |
141.8030 |
2024-06-19 00:00:00.0 |
7.5282 |
243 |
15 |
150.6267 |
2024-06-20 00:00:00.0 |
8.8237 |
243 |
16 |
159.2267 |
2024-06-21 00:00:00.0 |
8.6000 |
243 |
17 |
167.9765 |
2024-06-22 00:00:00.0 |
8.7498 |
243 |
18 |
176.7168 |
2024-06-23 00:00:00.0 |
8.7403 |
243 |
19 |
184.2287 |
2024-06-24 00:00:00.0 |
7.5119 |
243 |
20 |
193.3067 |
2024-06-25 00:00:00.0 |
9.0780 |
243 |
21 |
201.2776 |
2024-06-26 00:00:00.0 |
7.9709 |
243 |
22 |
208.5802 |
2024-06-27 00:00:00.0 |
7.3026 |
243 |
23 |
215.1645 |
2024-06-28 00:00:00.0 |
6.5843 |
243 |
24 |
222.3634 |
2024-06-29 00:00:00.0 |
7.1989 |
243 |
25 |
228.6309 |
2024-06-30 00:00:00.0 |
6.2675 |
243 |
26 |
237.2917 |
2024-07-01 00:00:00.0 |
8.6608 |
243 |
27 |
246.5997 |
2024-07-02 00:00:00.0 |
9.3080 |
243 |
28 |
255.6510 |
2024-07-03 00:00:00.0 |
9.0513 |
243 |
29 |
264.3910 |
2024-07-04 00:00:00.0 |
8.7400 |
243 |
30 |
273.3648 |
2024-07-05 00:00:00.0 |
8.9738 |
243 |
31 |
281.8925 |
2024-07-06 00:00:00.0 |
8.5277 |
243 |
32 |
290.5191 |
2024-07-07 00:00:00.0 |
8.6266 |
243 |
33 |
299.1563 |
2024-07-08 00:00:00.0 |
8.6372 |
243 |
34 |
307.4303 |
2024-07-09 00:00:00.0 |
8.2740 |
243 |
35 |
315.5954 |
2024-07-10 00:00:00.0 |
8.1651 |
243 |
36 |
322.9232 |
2024-07-11 00:00:00.0 |
7.3278 |
243 |
37 |
329.9922 |
2024-07-12 00:00:00.0 |
7.0690 |
243 |
38 |
338.4939 |
2024-07-13 00:00:00.0 |
8.5017 |
243 |
39 |
347.2837 |
2024-07-14 00:00:00.0 |
8.7898 |
243 |
40 |
356.5780 |
2024-07-15 00:00:00.0 |
9.2943 |
243 |
41 |
365.0587 |
2024-07-16 00:00:00.0 |
8.4807 |
243 |
42 |
372.4530 |
2024-07-17 00:00:00.0 |
7.3943 |
243 |
43 |
380.5657 |
2024-07-18 00:00:00.0 |
8.1127 |
243 |
44 |
389.0941 |
2024-07-19 00:00:00.0 |
8.5284 |
243 |
45 |
396.7967 |
2024-07-20 00:00:00.0 |
7.7026 |
243 |
46 |
405.5790 |
2024-07-21 00:00:00.0 |
8.7823 |
243 |
47 |
414.8908 |
2024-07-22 00:00:00.0 |
9.3118 |
243 |
48 |
424.4985 |
2024-07-23 00:00:00.0 |
9.6077 |
243 |
49 |
433.4470 |
2024-07-24 00:00:00.0 |
8.9485 |
243 |
50 |
442.0948 |
2024-07-25 00:00:00.0 |
8.6478 |
243 |
51 |
449.7792 |
2024-07-26 00:00:00.0 |
7.6844 |
243 |
52 |
458.2290 |
2024-07-27 00:00:00.0 |
8.4498 |
243 |
53 |
467.5253 |
2024-07-28 00:00:00.0 |
9.2963 |
243 |
54 |
476.0119 |
2024-07-29 00:00:00.0 |
8.4866 |
243 |
55 |
483.9231 |
2024-07-30 00:00:00.0 |
7.9112 |
243 |
56 |
492.4032 |
2024-07-31 00:00:00.0 |
8.4801 |
243 |
57 |
499.7043 |
2024-08-01 00:00:00.0 |
7.3011 |
243 |
58 |
508.0976 |
2024-08-02 00:00:00.0 |
8.3933 |
243 |
59 |
517.4563 |
2024-08-03 00:00:00.0 |
9.3587 |
243 |
60 |
524.5378 |
2024-08-04 00:00:00.0 |
7.0815 |
243 |
61 |
533.1607 |
2024-08-05 00:00:00.0 |
8.6229 |
243 |
62 |
540.2472 |
2024-08-06 00:00:00.0 |
7.0865 |
243 |
63 |
548.2170 |
2024-08-07 00:00:00.0 |
7.9698 |
243 |
64 |
554.9245 |
2024-08-08 00:00:00.0 |
6.7075 |
243 |
65 |
561.6559 |
2024-08-09 00:00:00.0 |
6.7314 |
243 |
66 |
568.3993 |
2024-08-10 00:00:00.0 |
6.7434 |
243 |
67 |
575.6755 |
2024-08-11 00:00:00.0 |
7.2762 |
243 |
68 |
583.3346 |
2024-08-12 00:00:00.0 |
7.6591 |
243 |
69 |
591.6811 |
2024-08-13 00:00:00.0 |
8.3465 |
243 |
70 |
601.0099 |
2024-08-14 00:00:00.0 |
9.3288 |
243 |
71 |
610.8026 |
2024-08-15 00:00:00.0 |
9.7927 |
243 |
72 |
620.1666 |
2024-08-16 00:00:00.0 |
9.3640 |
243 |
73 |
629.2252 |
2024-08-17 00:00:00.0 |
9.0586 |
243 |
74 |
637.0253 |
2024-08-18 00:00:00.0 |
7.8001 |
243 |
75 |
645.2036 |
2024-08-19 00:00:00.0 |
8.1783 |
243 |
76 |
653.3894 |
2024-08-20 00:00:00.0 |
8.1858 |
243 |
77 |
662.3094 |
2024-08-21 00:00:00.0 |
8.9200 |
243 |
78 |
671.3892 |
2024-08-22 00:00:00.0 |
9.0798 |
243 |
79 |
679.7054 |
2024-08-23 00:00:00.0 |
8.3162 |
243 |
80 |
687.3216 |
2024-08-24 00:00:00.0 |
7.6162 |
243 |
81 |
694.4120 |
2024-08-25 00:00:00.0 |
7.0904 |
243 |
82 |
702.6070 |
2024-08-26 00:00:00.0 |
8.1950 |
243 |
83 |
709.5848 |
2024-08-27 00:00:00.0 |
6.9778 |
243 |
84 |
717.4701 |
2024-08-28 00:00:00.0 |
7.8853 |
243 |
85 |
725.9287 |
2024-08-29 00:00:00.0 |
8.4586 |
243 |
86 |
734.3438 |
2024-08-30 00:00:00.0 |
8.4151 |
243 |
87 |
741.9721 |
2024-08-31 00:00:00.0 |
7.6283 |
243 |
88 |
748.1413 |
2024-09-01 00:00:00.0 |
6.1692 |
243 |
89 |
756.0099 |
2024-09-02 00:00:00.0 |
7.8686 |
243 |
90 |
763.9590 |
2024-09-03 00:00:00.0 |
7.9491 |
243 |
91 |
773.4388 |
2024-09-04 00:00:00.0 |
9.4798 |
243 |
92 |
780.5999 |
2024-09-05 00:00:00.0 |
7.1611 |
243 |
93 |
786.2988 |
2024-09-06 00:00:00.0 |
5.6989 |
243 |
94 |
792.4219 |
2024-09-07 00:00:00.0 |
6.1231 |
243 |
95 |
799.3839 |
2024-09-08 00:00:00.0 |
6.9620 |
243 |
96 |
806.8454 |
2024-09-09 00:00:00.0 |
7.4615 |
243 |
97 |
815.6394 |
2024-09-10 00:00:00.0 |
8.7940 |
243 |
98 |
823.1006 |
2024-09-11 00:00:00.0 |
7.4612 |
243 |
99 |
830.7014 |
2024-09-12 00:00:00.0 |
7.6008 |
243 |
100 |
840.1532 |
2024-09-13 00:00:00.0 |
9.4518 |
243 |
101 |
848.6047 |
2024-09-14 00:00:00.0 |
8.4515 |
243 |
102 |
856.5126 |
2024-09-15 00:00:00.0 |
7.9079 |
243 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '243') AND ddate BETWEEN {d '2024-06-06'} AND {d '2024-09-15'}
ORDER BY ddate ASC |