P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	7.8444	2017-05-15 00:00:00.0	7.8444	239
2	15.0505	2017-05-16 00:00:00.0	7.2061	239
3	15.1928	2017-05-17 00:00:00.0	0.1423	239
4	15.1928	2017-05-18 00:00:00.0	0.0000	239
5	17.8459	2017-05-19 00:00:00.0	2.6531	239
6	23.5275	2017-05-20 00:00:00.0	5.6816	239
7	26.6622	2017-05-21 00:00:00.0	3.1347	239
8	31.8617	2017-05-22 00:00:00.0	5.1995	239
9	39.3617	2017-05-23 00:00:00.0	7.5000	239
10	47.1393	2017-05-24 00:00:00.0	7.7776	239
11	54.1924	2017-05-25 00:00:00.0	7.0531	239
12	60.5924	2017-05-26 00:00:00.0	6.4000	239
13	67.9475	2017-05-27 00:00:00.0	7.3551	239
14	73.9965	2017-05-28 00:00:00.0	6.0490	239
15	77.8230	2017-05-29 00:00:00.0	3.8265	239
16	84.0495	2017-05-30 00:00:00.0	6.2265	239
17	92.8740	2017-05-31 00:00:00.0	8.8245	239
18	102.8413	2017-06-01 00:00:00.0	9.9673	239
19	111.9413	2017-06-02 00:00:00.0	9.1000	239
20	121.9331	2017-06-03 00:00:00.0	9.9918	239
21	131.7081	2017-06-04 00:00:00.0	9.7750	239
22	141.7035	2017-06-05 00:00:00.0	9.9954	239
23	151.5561	2017-06-06 00:00:00.0	9.8526	239
24	160.8194	2017-06-07 00:00:00.0	9.2633	239
25	170.6720	2017-06-08 00:00:00.0	9.8526	239
26	180.0108	2017-06-09 00:00:00.0	9.3388	239
27	189.5817	2017-06-10 00:00:00.0	9.5709	239
28	198.9919	2017-06-11 00:00:00.0	9.4102	239
29	207.8649	2017-06-12 00:00:00.0	8.8730	239
30	216.5379	2017-06-13 00:00:00.0	8.6730	239
31	224.9945	2017-06-14 00:00:00.0	8.4566	239
32	233.0960	2017-06-15 00:00:00.0	8.1015	239
33	241.6082	2017-06-16 00:00:00.0	8.5122	239
34	248.9633	2017-06-17 00:00:00.0	7.3551	239
35	256.2444	2017-06-18 00:00:00.0	7.2811	239
36	264.1546	2017-06-19 00:00:00.0	7.9102	239
37	272.2561	2017-06-20 00:00:00.0	8.1015	239
38	281.3984	2017-06-21 00:00:00.0	9.1423	239
39	289.2428	2017-06-22 00:00:00.0	7.8444	239
40	295.6428	2017-06-23 00:00:00.0	6.4000	239
41	299.4693	2017-06-24 00:00:00.0	3.8265	239
42	305.1509	2017-06-25 00:00:00.0	5.6816	239
43	312.9285	2017-06-26 00:00:00.0	7.7776	239
44	322.7811	2017-06-27 00:00:00.0	9.8526	239
45	332.7398	2017-06-28 00:00:00.0	9.9587	239
46	342.0413	2017-06-29 00:00:00.0	9.3015	239
47	350.4413	2017-06-30 00:00:00.0	8.4000	239
48	359.4535	2017-07-01 00:00:00.0	9.0122	239
49	367.7958	2017-07-02 00:00:00.0	8.3423	239
50	377.7830	2017-07-03 00:00:00.0	9.9872	239
51	386.8830	2017-07-04 00:00:00.0	9.1000	239
52	396.8632	2017-07-05 00:00:00.0	9.9802	239
53	406.8550	2017-07-06 00:00:00.0	9.9918	239
54	416.5611	2017-07-07 00:00:00.0	9.7061	239
55	426.5599	2017-07-08 00:00:00.0	9.9988	239
56	436.5401	2017-07-09 00:00:00.0	9.9802	239
57	446.4796	2017-07-10 00:00:00.0	9.9395	239
58	456.4469	2017-07-11 00:00:00.0	9.9673	239
59	465.1199	2017-07-12 00:00:00.0	8.6730	239
60	473.9929	2017-07-13 00:00:00.0	8.8730	239
61	483.9801	2017-07-14 00:00:00.0	9.9872	239
62	493.8495	2017-07-15 00:00:00.0	9.8694	239
63	503.7495	2017-07-16 00:00:00.0	9.9000	239
64	513.6890	2017-07-17 00:00:00.0	9.9395	239
65	522.7890	2017-07-18 00:00:00.0	9.1000	239
66	532.0130	2017-07-19 00:00:00.0	9.2240	239
67	541.6130	2017-07-20 00:00:00.0	9.6000	239
68	551.4824	2017-07-21 00:00:00.0	9.8694	239
69	560.8574	2017-07-22 00:00:00.0	9.3750	239
70	570.6105	2017-07-23 00:00:00.0	9.7531	239
71	580.4327	2017-07-24 00:00:00.0	9.8222	239
72	590.2485	2017-07-25 00:00:00.0	9.8158	239
73	600.1975	2017-07-26 00:00:00.0	9.9490	239
74	610.1893	2017-07-27 00:00:00.0	9.9918	239
75	620.1103	2017-07-28 00:00:00.0	9.9210	239
76	630.0659	2017-07-29 00:00:00.0	9.9556	239
77	639.4684	2017-07-30 00:00:00.0	9.4025	239
78	648.1240	2017-07-31 00:00:00.0	8.6556	239
79	657.8990	2017-08-01 00:00:00.0	9.7750	239
80	665.4699	2017-08-02 00:00:00.0	7.5709	239
81	674.4821	2017-08-03 00:00:00.0	9.0122	239
82	683.6244	2017-08-04 00:00:00.0	9.1423	239
83	692.6366	2017-08-05 00:00:00.0	9.0122	239
84	701.4611	2017-08-06 00:00:00.0	8.8245	239
85	711.1162	2017-08-07 00:00:00.0	9.6551	239
86	720.8693	2017-08-08 00:00:00.0	9.7531	239
87	729.2693	2017-08-09 00:00:00.0	8.4000	239
88	738.3693	2017-08-10 00:00:00.0	9.1000	239
89	747.7795	2017-08-11 00:00:00.0	9.4102	239
90	757.0428	2017-08-12 00:00:00.0	9.2633	239
91	766.4872	2017-08-13 00:00:00.0	9.4444	239
92	776.0581	2017-08-14 00:00:00.0	9.5709	239
93	785.3214	2017-08-15 00:00:00.0	9.2633	239
94	795.0515	2017-08-16 00:00:00.0	9.7301	239
95	804.4265	2017-08-17 00:00:00.0	9.3750	239
96	814.2423	2017-08-18 00:00:00.0	9.8158	239
97	824.2403	2017-08-19 00:00:00.0	9.9980	239
98	833.2969	2017-08-20 00:00:00.0	9.0566	239
99	841.8637	2017-08-21 00:00:00.0	8.5668	239
100	850.1474	2017-08-22 00:00:00.0	8.2837	239
101	857.1224	2017-08-23 00:00:00.0	6.9750	239
102	864.6933	2017-08-24 00:00:00.0	7.5709	239
103	874.4234	2017-08-25 00:00:00.0	9.7301	239
104	883.9331	2017-08-26 00:00:00.0	9.5097	239
105	893.4107	2017-08-27 00:00:00.0	9.4776	239
106	903.3923	2017-08-28 00:00:00.0	9.9816	239
107	913.3903	2017-08-29 00:00:00.0	9.9980	239
108	921.9025	2017-08-30 00:00:00.0	8.5122	239
109	931.7551	2017-08-31 00:00:00.0	9.8526	239
110	941.7551	2017-09-01 00:00:00.0	10.0000	239
111	951.3832	2017-09-02 00:00:00.0	9.6281	239
112	961.0383	2017-09-03 00:00:00.0	9.6551	239
113	969.0771	2017-09-04 00:00:00.0	8.0388	239
114	975.3036	2017-09-05 00:00:00.0	6.2265	239
115	982.8745	2017-09-06 00:00:00.0	7.5709	239
116	991.5475	2017-09-07 00:00:00.0	8.6730	239
117	998.9026	2017-09-08 00:00:00.0	7.3551	239
118	1008.6557	2017-09-09 00:00:00.0	9.7531	239
119	1018.5063	2017-09-10 00:00:00.0	9.8506	239
120	1028.0772	2017-09-11 00:00:00.0	9.5709	239
121	1038.0661	2017-09-12 00:00:00.0	9.9889	239
122	1046.5227	2017-09-13 00:00:00.0	8.4566	239
123	1052.3900	2017-09-14 00:00:00.0	5.8673	239
124	1055.4058	2017-09-15 00:00:00.0	3.0158	239
125	1056.1073	2017-09-16 00:00:00.0	0.7015	239
126	1058.0073	2017-09-17 00:00:00.0	1.9000	239
127	1063.5945	2017-09-18 00:00:00.0	5.5872	239
128	1071.2353	2017-09-19 00:00:00.0	7.6408	239
129	1078.5904	2017-09-20 00:00:00.0	7.3551	239
130	1085.0756	2017-09-21 00:00:00.0	6.4852	239
131	1087.9715	2017-09-22 00:00:00.0	2.8959	239
132	1091.6853	2017-09-23 00:00:00.0	3.7138	239
133	1094.4603	2017-09-24 00:00:00.0	2.7750	239
134	1097.2353	2017-09-25 00:00:00.0	2.7750	239
135	1097.9368	2017-09-26 00:00:00.0	0.7015	239
136	1103.7118	2017-09-27 00:00:00.0	5.7750	239
137	1109.2036	2017-09-28 00:00:00.0	5.4918	239
138	1109.9051	2017-09-29 00:00:00.0	0.7015	239
139	1117.1862	2017-09-30 00:00:00.0	7.2811	239
140	1125.2877	2017-10-01 00:00:00.0	8.1015	239
141	1130.1857	2017-10-02 00:00:00.0	4.8980	239
142	1130.1857	2017-10-03 00:00:00.0	0.0000	239
143	1130.7490	2017-10-04 00:00:00.0	0.5633	239
144	1130.7490	2017-10-05 00:00:00.0	0.0000	239
145	1133.6449	2017-10-06 00:00:00.0	2.8959	239
146	1140.6199	2017-10-07 00:00:00.0	6.9750	239
147	1141.9975	2017-10-08 00:00:00.0	1.3776	239
148	1141.9975	2017-10-09 00:00:00.0	0.0000	239
149	1143.7684	2017-10-10 00:00:00.0	1.7709	239
150	1146.5434	2017-10-11 00:00:00.0	2.7750	239
151	1146.6857	2017-10-12 00:00:00.0	0.1423	239
152	1146.6857	2017-10-13 00:00:00.0	0.0000	239
153	1146.6857	2017-10-14 00:00:00.0	0.0000	239
154	1146.6857	2017-10-15 00:00:00.0	0.0000	239
155	1147.7959	2017-10-16 00:00:00.0	1.1102	239
156	1153.0939	2017-10-17 00:00:00.0	5.2980	239
157	1158.6811	2017-10-18 00:00:00.0	5.5872	239
158	1161.0872	2017-10-19 00:00:00.0	2.4061	239
159	1167.8219	2017-10-20 00:00:00.0	6.7347	239
160	1173.0214	2017-10-21 00:00:00.0	5.1995	239
161	1174.3990	2017-10-22 00:00:00.0	1.3776	239
162	1174.3990	2017-10-23 00:00:00.0	0.0000	239
163	1174.3990	2017-10-24 00:00:00.0	0.0000	239
164	1174.3990	2017-10-25 00:00:00.0	0.0000	239
165	1174.3990	2017-10-26 00:00:00.0	0.0000	239
166	1174.3990	2017-10-27 00:00:00.0	0.0000	239
167	1174.3990	2017-10-28 00:00:00.0	0.0000	239
168	1174.3990	2017-10-29 00:00:00.0	0.0000	239
169	1174.3990	2017-10-30 00:00:00.0	0.0000	239
170	1174.3990	2017-10-31 00:00:00.0	0.0000	239

CACHED

false

EXECUTIONTIME

SQL

SELECT * FROM WIN_MB_MAWP.dbo.PM_PDays WHERE (TStnID = '239') AND ddate < '2017-11-01' ORDER BY ddate ASC

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1174
10/30/2017	0	1174
10/29/2017	0	1174
10/28/2017	0	1174
10/27/2017	0	1174
10/26/2017	0	1174
10/25/2017	0	1174
10/24/2017	0	1174
10/23/2017	0	1174
10/22/2017	1	1174
10/21/2017	5	1173
10/20/2017	7	1168
10/19/2017	2	1161
10/18/2017	6	1159
10/17/2017	5	1153
10/16/2017	1	1148
10/15/2017	0	1147
10/14/2017	0	1147
10/13/2017	0	1147
10/12/2017	0	1147
10/11/2017	3	1147
10/10/2017	2	1144
10/9/2017	0	1142
10/8/2017	1	1142
10/7/2017	7	1141
10/6/2017	3	1134
10/5/2017	0	1131
10/4/2017	1	1131
10/3/2017	0	1130
10/2/2017	5	1130
10/1/2017	8	1125
9/30/2017	7	1117
9/29/2017	1	1110
9/28/2017	5	1109
9/27/2017	6	1104
9/26/2017	1	1098
9/25/2017	3	1097
9/24/2017	3	1094
9/23/2017	4	1092
9/22/2017	3	1088
9/21/2017	6	1085
9/20/2017	7	1079
9/19/2017	8	1071
9/18/2017	6	1064
9/17/2017	2	1058
9/16/2017	1	1056
9/15/2017	3	1055
9/14/2017	6	1052
9/13/2017	8	1047
9/12/2017	10	1038
9/11/2017	10	1028
9/10/2017	10	1019
9/9/2017	10	1009
9/8/2017	7	999
9/7/2017	9	992
9/6/2017	8	983
9/5/2017	6	975
9/4/2017	8	969
9/3/2017	10	961
9/2/2017	10	951
9/1/2017	10	942
8/31/2017	10	932
8/30/2017	9	922
8/29/2017	10	913
8/28/2017	10	903
8/27/2017	9	893
8/26/2017	10	884
8/25/2017	10	874
8/24/2017	8	865
8/23/2017	7	857
8/22/2017	8	850
8/21/2017	9	842
8/20/2017	9	833
8/19/2017	10	824
8/18/2017	10	814
8/17/2017	9	804
8/16/2017	10	795
8/15/2017	9	785
8/14/2017	10	776
8/13/2017	9	766
8/12/2017	9	757
8/11/2017	9	748
8/10/2017	9	738
8/9/2017	8	729
8/8/2017	10	721
8/7/2017	10	711
8/6/2017	9	701
8/5/2017	9	693
8/4/2017	9	684
8/3/2017	9	674
8/2/2017	8	665
8/1/2017	10	658
7/31/2017	9	648
7/30/2017	9	639
7/29/2017	10	630
7/28/2017	10	620
7/27/2017	10	610
7/26/2017	10	600
7/25/2017	10	590
7/24/2017	10	580
7/23/2017	10	571
7/22/2017	9	561
7/21/2017	10	551
7/20/2017	10	542
7/19/2017	9	532
7/18/2017	9	523
7/17/2017	10	514
7/16/2017	10	504
7/15/2017	10	494
7/14/2017	10	484
7/13/2017	9	474
7/12/2017	9	465
7/11/2017	10	456
7/10/2017	10	446
7/9/2017	10	437
7/8/2017	10	427
7/7/2017	10	417
7/6/2017	10	407
7/5/2017	10	397
7/4/2017	9	387
7/3/2017	10	378
7/2/2017	8	368
7/1/2017	9	359
6/30/2017	8	350
6/29/2017	9	342
6/28/2017	10	333
6/27/2017	10	323
6/26/2017	8	313
6/25/2017	6	305
6/24/2017	4	299
6/23/2017	6	296
6/22/2017	8	289
6/21/2017	9	281
6/20/2017	8	272
6/19/2017	8	264
6/18/2017	7	256
6/17/2017	7	249
6/16/2017	9	242
6/15/2017	8	233
6/14/2017	8	225
6/13/2017	9	217
6/12/2017	9	208
6/11/2017	9	199
6/10/2017	10	190
6/9/2017	9	180
6/8/2017	10	171
6/7/2017	9	161
6/6/2017	10	152
6/5/2017	10	142
6/4/2017	10	132
6/3/2017	10	122
6/2/2017	9	112
6/1/2017	10	103
5/31/2017	9	93
5/30/2017	6	84
5/29/2017	4	78
5/28/2017	6	74
5/27/2017	7	68
5/26/2017	6	61
5/25/2017	7	54
5/24/2017	8	47
5/23/2017	8	39
5/22/2017	5	32
5/21/2017	3	27
5/20/2017	6	24
5/19/2017	3	18
5/18/2017	0	15
5/17/2017	0	15
5/16/2017	7	15
5/15/2017	8	8

mbpotatoes.ca

Physiological Days