P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	9.3388	2017-05-15 00:00:00.0	9.3388	212
2	16.7669	2017-05-16 00:00:00.0	7.4281	212
3	18.1445	2017-05-17 00:00:00.0	1.3776	212
4	18.5685	2017-05-18 00:00:00.0	0.4240	212
5	22.3950	2017-05-19 00:00:00.0	3.8265	212
6	28.0766	2017-05-20 00:00:00.0	5.6816	212
7	29.8475	2017-05-21 00:00:00.0	1.7709	212
8	33.5613	2017-05-22 00:00:00.0	3.7138	212
9	40.7674	2017-05-23 00:00:00.0	7.2061	212
10	48.6776	2017-05-24 00:00:00.0	7.9102	212
11	56.3873	2017-05-25 00:00:00.0	7.7097	212
12	64.1649	2017-05-26 00:00:00.0	7.7776	212
13	71.9425	2017-05-27 00:00:00.0	7.7776	212
14	77.2405	2017-05-28 00:00:00.0	5.2980	212
15	79.8936	2017-05-29 00:00:00.0	2.6531	212
16	85.9426	2017-05-30 00:00:00.0	6.0490	212
17	94.9992	2017-05-31 00:00:00.0	9.0566	212
18	104.9910	2017-06-01 00:00:00.0	9.9918	212
19	113.4787	2017-06-02 00:00:00.0	8.4877	212
20	123.3293	2017-06-03 00:00:00.0	9.8506	212
21	133.1819	2017-06-04 00:00:00.0	9.8526	212
22	143.1375	2017-06-05 00:00:00.0	9.9556	212
23	153.1177	2017-06-06 00:00:00.0	9.9802	212
24	162.7988	2017-06-07 00:00:00.0	9.6811	212
25	172.7968	2017-06-08 00:00:00.0	9.9980	212
26	182.5029	2017-06-09 00:00:00.0	9.7061	212
27	192.3187	2017-06-10 00:00:00.0	9.8158	212
28	202.1345	2017-06-11 00:00:00.0	9.8158	212
29	211.3585	2017-06-12 00:00:00.0	9.2240	212
30	220.5422	2017-06-13 00:00:00.0	9.1837	212
31	229.8437	2017-06-14 00:00:00.0	9.3015	212
32	238.5167	2017-06-15 00:00:00.0	8.6730	212
33	247.3412	2017-06-16 00:00:00.0	8.8245	212
34	255.2514	2017-06-17 00:00:00.0	7.9102	212
35	262.6065	2017-06-18 00:00:00.0	7.3551	212
36	270.7698	2017-06-19 00:00:00.0	8.1633	212
37	279.2264	2017-06-20 00:00:00.0	8.4566	212
38	287.8994	2017-06-21 00:00:00.0	8.6730	212
39	296.2994	2017-06-22 00:00:00.0	8.4000	212
40	303.5805	2017-06-23 00:00:00.0	7.2811	212
41	307.8478	2017-06-24 00:00:00.0	4.2673	212
42	313.7151	2017-06-25 00:00:00.0	5.8673	212
43	322.0574	2017-06-26 00:00:00.0	8.3423	212
44	331.8533	2017-06-27 00:00:00.0	9.7959	212
45	341.6283	2017-06-28 00:00:00.0	9.7750	212
46	350.9671	2017-06-29 00:00:00.0	9.3388	212
47	359.6916	2017-06-30 00:00:00.0	8.7245	212
48	368.4666	2017-07-01 00:00:00.0	8.7750	212
49	377.2416	2017-07-02 00:00:00.0	8.7750	212
50	387.2089	2017-07-03 00:00:00.0	9.9673	212
51	396.8929	2017-07-04 00:00:00.0	9.6840	212
52	406.4472	2017-07-05 00:00:00.0	9.5543	212
53	416.2386	2017-07-06 00:00:00.0	9.7914	212
54	426.0136	2017-07-07 00:00:00.0	9.7750	212
55	436.0025	2017-07-08 00:00:00.0	9.9889	212
56	446.0013	2017-07-09 00:00:00.0	9.9988	212
57	455.9967	2017-07-10 00:00:00.0	9.9954	212
58	465.9105	2017-07-11 00:00:00.0	9.9138	212
59	474.4227	2017-07-12 00:00:00.0	8.5122	212
60	483.3895	2017-07-13 00:00:00.0	8.9668	212
61	493.3278	2017-07-14 00:00:00.0	9.9383	212
62	503.3150	2017-07-15 00:00:00.0	9.9872	212
63	513.0681	2017-07-16 00:00:00.0	9.7531	212
64	522.6224	2017-07-17 00:00:00.0	9.5543	212
65	532.1321	2017-07-18 00:00:00.0	9.5097	212
66	541.0989	2017-07-19 00:00:00.0	8.9668	212
67	550.8948	2017-07-20 00:00:00.0	9.7959	212
68	560.8213	2017-07-21 00:00:00.0	9.9265	212
69	570.3621	2017-07-22 00:00:00.0	9.5408	212
70	580.2621	2017-07-23 00:00:00.0	9.9000	212
71	590.2423	2017-07-24 00:00:00.0	9.9802	212
72	600.2295	2017-07-25 00:00:00.0	9.9872	212
73	610.2295	2017-07-26 00:00:00.0	10.0000	212
74	620.1851	2017-07-27 00:00:00.0	9.9556	212
75	630.0073	2017-07-28 00:00:00.0	9.8222	212
76	639.9629	2017-07-29 00:00:00.0	9.9556	212
77	649.1913	2017-07-30 00:00:00.0	9.2284	212
78	657.7641	2017-07-31 00:00:00.0	8.5728	212
79	667.6906	2017-08-01 00:00:00.0	9.9265	212
80	675.7294	2017-08-02 00:00:00.0	8.0388	212
81	684.7416	2017-08-03 00:00:00.0	9.0122	212
82	694.0049	2017-08-04 00:00:00.0	9.2633	212
83	703.3064	2017-08-05 00:00:00.0	9.3015	212
84	712.5304	2017-08-06 00:00:00.0	9.2240	212
85	722.3651	2017-08-07 00:00:00.0	9.8347	212
86	732.2177	2017-08-08 00:00:00.0	9.8526	212
87	741.5192	2017-08-09 00:00:00.0	9.3015	212
88	751.1192	2017-08-10 00:00:00.0	9.6000	212
89	760.4942	2017-08-11 00:00:00.0	9.3750	212
90	770.0942	2017-08-12 00:00:00.0	9.6000	212
91	779.9468	2017-08-13 00:00:00.0	9.8526	212
92	789.7994	2017-08-14 00:00:00.0	9.8526	212
93	799.4275	2017-08-15 00:00:00.0	9.6281	212
94	809.2622	2017-08-16 00:00:00.0	9.8347	212
95	818.9173	2017-08-17 00:00:00.0	9.6551	212
96	828.8438	2017-08-18 00:00:00.0	9.9265	212
97	838.8129	2017-08-19 00:00:00.0	9.9691	212
98	848.5879	2017-08-20 00:00:00.0	9.7750	212
99	856.6894	2017-08-21 00:00:00.0	8.1015	212
100	865.2562	2017-08-22 00:00:00.0	8.5668	212
101	871.6562	2017-08-23 00:00:00.0	6.4000	212
102	879.1562	2017-08-24 00:00:00.0	7.5000	212
103	888.4195	2017-08-25 00:00:00.0	9.2633	212
104	897.9292	2017-08-26 00:00:00.0	9.5097	212
105	907.7450	2017-08-27 00:00:00.0	9.8158	212
106	917.6215	2017-08-28 00:00:00.0	9.8765	212
107	927.6166	2017-08-29 00:00:00.0	9.9951	212
108	937.0268	2017-08-30 00:00:00.0	9.4102	212
109	946.4370	2017-08-31 00:00:00.0	9.4102	212
110	956.2329	2017-09-01 00:00:00.0	9.7959	212
111	965.9390	2017-09-02 00:00:00.0	9.7061	212
112	975.4487	2017-09-03 00:00:00.0	9.5097	212
113	984.1217	2017-09-04 00:00:00.0	8.6730	212
114	991.2518	2017-09-05 00:00:00.0	7.1301	212
115	997.9044	2017-09-06 00:00:00.0	6.6526	212
116	1007.2794	2017-09-07 00:00:00.0	9.3750	212
117	1014.2544	2017-09-08 00:00:00.0	6.9750	212
118	1023.3544	2017-09-09 00:00:00.0	9.1000	212
119	1033.1458	2017-09-10 00:00:00.0	9.7914	212
120	1043.0723	2017-09-11 00:00:00.0	9.9265	212
121	1052.0340	2017-09-12 00:00:00.0	8.9617	212
122	1061.4090	2017-09-13 00:00:00.0	9.3750	212
123	1068.6901	2017-09-14 00:00:00.0	7.2811	212
124	1072.5166	2017-09-15 00:00:00.0	3.8265	212
125	1074.0263	2017-09-16 00:00:00.0	1.5097	212
126	1077.0421	2017-09-17 00:00:00.0	3.0158	212
127	1082.0416	2017-09-18 00:00:00.0	4.9995	212
128	1090.4416	2017-09-19 00:00:00.0	8.4000	212
129	1098.7253	2017-09-20 00:00:00.0	8.2837	212
130	1106.5029	2017-09-21 00:00:00.0	7.7776	212
131	1112.8167	2017-09-22 00:00:00.0	6.3138	212
132	1117.7147	2017-09-23 00:00:00.0	4.8980	212
133	1121.1999	2017-09-24 00:00:00.0	3.4852	212
134	1124.4525	2017-09-25 00:00:00.0	3.2526	212
135	1125.8301	2017-09-26 00:00:00.0	1.3776	212
136	1130.8296	2017-09-27 00:00:00.0	4.9995	212
137	1136.4168	2017-09-28 00:00:00.0	5.5872	212
138	1138.1877	2017-09-29 00:00:00.0	1.7709	212
139	1144.2367	2017-09-30 00:00:00.0	6.0490	212
140	1151.8076	2017-10-01 00:00:00.0	7.5709	212
141	1158.4602	2017-10-02 00:00:00.0	6.6526	212
142	1159.2990	2017-10-03 00:00:00.0	0.8388	212
143	1161.7051	2017-10-04 00:00:00.0	2.4061	212
144	1161.8474	2017-10-05 00:00:00.0	0.1423	212
145	1164.3775	2017-10-06 00:00:00.0	2.5301	212
146	1170.8627	2017-10-07 00:00:00.0	6.4852	212
147	1174.2321	2017-10-08 00:00:00.0	3.3694	212
148	1174.2321	2017-10-09 00:00:00.0	0.0000	212
149	1174.9336	2017-10-10 00:00:00.0	0.7015	212
150	1176.4433	2017-10-11 00:00:00.0	1.5097	212
151	1178.8494	2017-10-12 00:00:00.0	2.4061	212
152	1178.8494	2017-10-13 00:00:00.0	0.0000	212
153	1178.8494	2017-10-14 00:00:00.0	0.0000	212
154	1178.8494	2017-10-15 00:00:00.0	0.0000	212
155	1180.7494	2017-10-16 00:00:00.0	1.9000	212
156	1186.5244	2017-10-17 00:00:00.0	5.7750	212
157	1193.1770	2017-10-18 00:00:00.0	6.6526	212
158	1195.4581	2017-10-19 00:00:00.0	2.2811	212
159	1202.1107	2017-10-20 00:00:00.0	6.6526	212
160	1209.5388	2017-10-21 00:00:00.0	7.4281	212
161	1212.7914	2017-10-22 00:00:00.0	3.2526	212
162	1212.7914	2017-10-23 00:00:00.0	0.0000	212
163	1212.7914	2017-10-24 00:00:00.0	0.0000	212
164	1213.6302	2017-10-25 00:00:00.0	0.8388	212
165	1213.6302	2017-10-26 00:00:00.0	0.0000	212
166	1213.6302	2017-10-27 00:00:00.0	0.0000	212
167	1213.6302	2017-10-28 00:00:00.0	0.0000	212
168	1213.6302	2017-10-29 00:00:00.0	0.0000	212
169	1213.6302	2017-10-30 00:00:00.0	0.0000	212
170	1213.6302	2017-10-31 00:00:00.0	0.0000	212

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1214
10/30/2017	0	1214
10/29/2017	0	1214
10/28/2017	0	1214
10/27/2017	0	1214
10/26/2017	0	1214
10/25/2017	1	1214
10/24/2017	0	1213
10/23/2017	0	1213
10/22/2017	3	1213
10/21/2017	7	1210
10/20/2017	7	1202
10/19/2017	2	1195
10/18/2017	7	1193
10/17/2017	6	1187
10/16/2017	2	1181
10/15/2017	0	1179
10/14/2017	0	1179
10/13/2017	0	1179
10/12/2017	2	1179
10/11/2017	2	1176
10/10/2017	1	1175
10/9/2017	0	1174
10/8/2017	3	1174
10/7/2017	6	1171
10/6/2017	3	1164
10/5/2017	0	1162
10/4/2017	2	1162
10/3/2017	1	1159
10/2/2017	7	1158
10/1/2017	8	1152
9/30/2017	6	1144
9/29/2017	2	1138
9/28/2017	6	1136
9/27/2017	5	1131
9/26/2017	1	1126
9/25/2017	3	1124
9/24/2017	3	1121
9/23/2017	5	1118
9/22/2017	6	1113
9/21/2017	8	1107
9/20/2017	8	1099
9/19/2017	8	1090
9/18/2017	5	1082
9/17/2017	3	1077
9/16/2017	2	1074
9/15/2017	4	1073
9/14/2017	7	1069
9/13/2017	9	1061
9/12/2017	9	1052
9/11/2017	10	1043
9/10/2017	10	1033
9/9/2017	9	1023
9/8/2017	7	1014
9/7/2017	9	1007
9/6/2017	7	998
9/5/2017	7	991
9/4/2017	9	984
9/3/2017	10	975
9/2/2017	10	966
9/1/2017	10	956
8/31/2017	9	946
8/30/2017	9	937
8/29/2017	10	928
8/28/2017	10	918
8/27/2017	10	908
8/26/2017	10	898
8/25/2017	9	888
8/24/2017	8	879
8/23/2017	6	872
8/22/2017	9	865
8/21/2017	8	857
8/20/2017	10	849
8/19/2017	10	839
8/18/2017	10	829
8/17/2017	10	819
8/16/2017	10	809
8/15/2017	10	799
8/14/2017	10	790
8/13/2017	10	780
8/12/2017	10	770
8/11/2017	9	760
8/10/2017	10	751
8/9/2017	9	742
8/8/2017	10	732
8/7/2017	10	722
8/6/2017	9	713
8/5/2017	9	703
8/4/2017	9	694
8/3/2017	9	685
8/2/2017	8	676
8/1/2017	10	668
7/31/2017	9	658
7/30/2017	9	649
7/29/2017	10	640
7/28/2017	10	630
7/27/2017	10	620
7/26/2017	10	610
7/25/2017	10	600
7/24/2017	10	590
7/23/2017	10	580
7/22/2017	10	570
7/21/2017	10	561
7/20/2017	10	551
7/19/2017	9	541
7/18/2017	10	532
7/17/2017	10	523
7/16/2017	10	513
7/15/2017	10	503
7/14/2017	10	493
7/13/2017	9	483
7/12/2017	9	474
7/11/2017	10	466
7/10/2017	10	456
7/9/2017	10	446
7/8/2017	10	436
7/7/2017	10	426
7/6/2017	10	416
7/5/2017	10	406
7/4/2017	10	397
7/3/2017	10	387
7/2/2017	9	377
7/1/2017	9	368
6/30/2017	9	360
6/29/2017	9	351
6/28/2017	10	342
6/27/2017	10	332
6/26/2017	8	322
6/25/2017	6	314
6/24/2017	4	308
6/23/2017	7	304
6/22/2017	8	296
6/21/2017	9	288
6/20/2017	8	279
6/19/2017	8	271
6/18/2017	7	263
6/17/2017	8	255
6/16/2017	9	247
6/15/2017	9	239
6/14/2017	9	230
6/13/2017	9	221
6/12/2017	9	211
6/11/2017	10	202
6/10/2017	10	192
6/9/2017	10	183
6/8/2017	10	173
6/7/2017	10	163
6/6/2017	10	153
6/5/2017	10	143
6/4/2017	10	133
6/3/2017	10	123
6/2/2017	8	113
6/1/2017	10	105
5/31/2017	9	95
5/30/2017	6	86
5/29/2017	3	80
5/28/2017	5	77
5/27/2017	8	72
5/26/2017	8	64
5/25/2017	8	56
5/24/2017	8	49
5/23/2017	7	41
5/22/2017	4	34
5/21/2017	2	30
5/20/2017	6	28
5/19/2017	4	22
5/18/2017	0	19
5/17/2017	1	18
5/16/2017	7	17
5/15/2017	9	9

mbpotatoes.ca

Physiological Days