query |
RESULTSET |
query |
|
ACCUPDAY |
DDATE |
PDAY |
TSTNID |
1 |
4.2028 |
2022-06-06 00:00:00.0 |
4.2028 |
239 |
2 |
9.7695 |
2022-06-07 00:00:00.0 |
5.5667 |
239 |
3 |
16.1463 |
2022-06-08 00:00:00.0 |
6.3768 |
239 |
4 |
22.5743 |
2022-06-09 00:00:00.0 |
6.4280 |
239 |
5 |
31.1012 |
2022-06-10 00:00:00.0 |
8.5269 |
239 |
6 |
39.7287 |
2022-06-11 00:00:00.0 |
8.6275 |
239 |
7 |
49.0695 |
2022-06-12 00:00:00.0 |
9.3408 |
239 |
8 |
58.4413 |
2022-06-13 00:00:00.0 |
9.3718 |
239 |
9 |
67.3488 |
2022-06-14 00:00:00.0 |
8.9075 |
239 |
10 |
74.5443 |
2022-06-15 00:00:00.0 |
7.1955 |
239 |
11 |
82.9153 |
2022-06-16 00:00:00.0 |
8.3710 |
239 |
12 |
90.9023 |
2022-06-17 00:00:00.0 |
7.9870 |
239 |
13 |
98.0194 |
2022-06-18 00:00:00.0 |
7.1171 |
239 |
14 |
102.1596 |
2022-06-19 00:00:00.0 |
4.1402 |
239 |
15 |
111.2410 |
2022-06-20 00:00:00.0 |
9.0814 |
239 |
16 |
120.5178 |
2022-06-21 00:00:00.0 |
9.2768 |
239 |
17 |
128.8089 |
2022-06-22 00:00:00.0 |
8.2911 |
239 |
18 |
135.9724 |
2022-06-23 00:00:00.0 |
7.1635 |
239 |
19 |
145.3007 |
2022-06-24 00:00:00.0 |
9.3283 |
239 |
20 |
152.6259 |
2022-06-25 00:00:00.0 |
7.3252 |
239 |
21 |
160.3944 |
2022-06-26 00:00:00.0 |
7.7685 |
239 |
22 |
168.4622 |
2022-06-27 00:00:00.0 |
8.0678 |
239 |
23 |
176.7257 |
2022-06-28 00:00:00.0 |
8.2635 |
239 |
24 |
184.6794 |
2022-06-29 00:00:00.0 |
7.9537 |
239 |
25 |
193.6385 |
2022-06-30 00:00:00.0 |
8.9591 |
239 |
26 |
200.7839 |
2022-07-01 00:00:00.0 |
7.1454 |
239 |
27 |
208.2234 |
2022-07-02 00:00:00.0 |
7.4395 |
239 |
28 |
216.2781 |
2022-07-03 00:00:00.0 |
8.0547 |
239 |
29 |
225.7386 |
2022-07-04 00:00:00.0 |
9.4605 |
239 |
30 |
235.1528 |
2022-07-05 00:00:00.0 |
9.4142 |
239 |
31 |
243.6351 |
2022-07-06 00:00:00.0 |
8.4823 |
239 |
32 |
252.6937 |
2022-07-07 00:00:00.0 |
9.0586 |
239 |
33 |
261.0707 |
2022-07-08 00:00:00.0 |
8.3770 |
239 |
34 |
268.7347 |
2022-07-09 00:00:00.0 |
7.6640 |
239 |
35 |
277.4207 |
2022-07-10 00:00:00.0 |
8.6860 |
239 |
36 |
286.7878 |
2022-07-11 00:00:00.0 |
9.3671 |
239 |
37 |
295.7205 |
2022-07-12 00:00:00.0 |
8.9327 |
239 |
38 |
304.0836 |
2022-07-13 00:00:00.0 |
8.3631 |
239 |
39 |
313.5369 |
2022-07-14 00:00:00.0 |
9.4533 |
239 |
40 |
322.1649 |
2022-07-15 00:00:00.0 |
8.6280 |
239 |
41 |
330.5248 |
2022-07-16 00:00:00.0 |
8.3599 |
239 |
42 |
336.4022 |
2022-07-17 00:00:00.0 |
5.8774 |
239 |
43 |
344.8782 |
2022-07-18 00:00:00.0 |
8.4760 |
239 |
44 |
354.4606 |
2022-07-19 00:00:00.0 |
9.5824 |
239 |
45 |
363.7592 |
2022-07-20 00:00:00.0 |
9.2986 |
239 |
46 |
372.4503 |
2022-07-21 00:00:00.0 |
8.6911 |
239 |
47 |
380.7643 |
2022-07-22 00:00:00.0 |
8.3140 |
239 |
48 |
389.7911 |
2022-07-23 00:00:00.0 |
9.0268 |
239 |
49 |
397.7327 |
2022-07-24 00:00:00.0 |
7.9416 |
239 |
50 |
405.6562 |
2022-07-25 00:00:00.0 |
7.9235 |
239 |
51 |
414.3714 |
2022-07-26 00:00:00.0 |
8.7152 |
239 |
52 |
422.1967 |
2022-07-27 00:00:00.0 |
7.8253 |
239 |
53 |
430.1821 |
2022-07-28 00:00:00.0 |
7.9854 |
239 |
54 |
438.1140 |
2022-07-29 00:00:00.0 |
7.9319 |
239 |
55 |
445.3456 |
2022-07-30 00:00:00.0 |
7.2316 |
239 |
56 |
454.3435 |
2022-07-31 00:00:00.0 |
8.9979 |
239 |
57 |
463.0284 |
2022-08-01 00:00:00.0 |
8.6849 |
239 |
58 |
470.6636 |
2022-08-02 00:00:00.0 |
7.6352 |
239 |
59 |
479.1993 |
2022-08-03 00:00:00.0 |
8.5357 |
239 |
60 |
486.4782 |
2022-08-04 00:00:00.0 |
7.2789 |
239 |
61 |
495.7352 |
2022-08-05 00:00:00.0 |
9.2570 |
239 |
62 |
503.5583 |
2022-08-06 00:00:00.0 |
7.8231 |
239 |
63 |
510.0465 |
2022-08-07 00:00:00.0 |
6.4882 |
239 |
64 |
517.5927 |
2022-08-08 00:00:00.0 |
7.5462 |
239 |
65 |
526.2361 |
2022-08-09 00:00:00.0 |
8.6434 |
239 |
66 |
533.3624 |
2022-08-10 00:00:00.0 |
7.1263 |
239 |
67 |
540.0730 |
2022-08-11 00:00:00.0 |
6.7106 |
239 |
68 |
549.4830 |
2022-08-12 00:00:00.0 |
9.4100 |
239 |
69 |
558.8930 |
2022-08-13 00:00:00.0 |
9.4100 |
239 |
|
CACHED |
false |
EXECUTIONTIME |
16 |
SQL |
SELECT *
FROM WIN_MB_MAWP.dbo.PM_PDays
WHERE (TStnID = '239') AND ddate BETWEEN {d '2022-06-06'} AND {d '2022-08-13'}
ORDER BY ddate ASC |