P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	9.3750	2017-05-15 00:00:00.0	9.3750	243
2	16.5051	2017-05-16 00:00:00.0	7.1301	243
3	17.8827	2017-05-17 00:00:00.0	1.3776	243
4	18.8577	2017-05-18 00:00:00.0	0.9750	243
5	23.6531	2017-05-19 00:00:00.0	4.7954	243
6	29.7021	2017-05-20 00:00:00.0	6.0490	243
7	31.3429	2017-05-21 00:00:00.0	1.6408	243
8	34.4776	2017-05-22 00:00:00.0	3.1347	243
9	41.8327	2017-05-23 00:00:00.0	7.3551	243
10	50.1750	2017-05-24 00:00:00.0	8.3423	243
11	58.2765	2017-05-25 00:00:00.0	8.1015	243
12	66.9495	2017-05-26 00:00:00.0	8.6730	243
13	75.2332	2017-05-27 00:00:00.0	8.2837	243
14	80.4327	2017-05-28 00:00:00.0	5.1995	243
15	82.3327	2017-05-29 00:00:00.0	1.9000	243
16	88.4710	2017-05-30 00:00:00.0	6.1383	243
17	97.0378	2017-05-31 00:00:00.0	8.5668	243
18	103.5699	2017-06-01 00:00:00.0	6.5321	243
19	111.3921	2017-06-02 00:00:00.0	7.8222	243
20	121.1501	2017-06-03 00:00:00.0	9.7580	243
21	130.9848	2017-06-04 00:00:00.0	9.8347	243
22	140.9058	2017-06-05 00:00:00.0	9.9210	243
23	150.3614	2017-06-06 00:00:00.0	9.4556	243
24	160.2466	2017-06-07 00:00:00.0	9.8852	243
25	170.2282	2017-06-08 00:00:00.0	9.9816	243
26	180.1772	2017-06-09 00:00:00.0	9.9490	243
27	190.1155	2017-06-10 00:00:00.0	9.9383	243
28	200.0538	2017-06-11 00:00:00.0	9.9383	243
29	209.0660	2017-06-12 00:00:00.0	9.0122	243
30	218.4410	2017-06-13 00:00:00.0	9.3750	243
31	227.8854	2017-06-14 00:00:00.0	9.4444	243
32	236.5058	2017-06-15 00:00:00.0	8.6204	243
33	244.7298	2017-06-16 00:00:00.0	8.2240	243
34	252.0109	2017-06-17 00:00:00.0	7.2811	243
35	259.2920	2017-06-18 00:00:00.0	7.2811	243
36	266.7201	2017-06-19 00:00:00.0	7.4281	243
37	275.4446	2017-06-20 00:00:00.0	8.7245	243
38	284.0114	2017-06-21 00:00:00.0	8.5668	243
39	292.1129	2017-06-22 00:00:00.0	8.1015	243
40	298.9287	2017-06-23 00:00:00.0	6.8158	243
41	303.4103	2017-06-24 00:00:00.0	4.4816	243
42	308.3083	2017-06-25 00:00:00.0	4.8980	243
43	316.4098	2017-06-26 00:00:00.0	8.1015	243
44	326.1629	2017-06-27 00:00:00.0	9.7531	243
45	335.7338	2017-06-28 00:00:00.0	9.5709	243
46	345.3889	2017-06-29 00:00:00.0	9.6551	243
47	354.2619	2017-06-30 00:00:00.0	8.8730	243
48	362.9349	2017-07-01 00:00:00.0	8.6730	243
49	371.4471	2017-07-02 00:00:00.0	8.5122	243
50	381.4287	2017-07-03 00:00:00.0	9.9816	243
51	391.1127	2017-07-04 00:00:00.0	9.6840	243
52	400.8707	2017-07-05 00:00:00.0	9.7580	243
53	410.8398	2017-07-06 00:00:00.0	9.9691	243
54	420.5459	2017-07-07 00:00:00.0	9.7061	243
55	430.5046	2017-07-08 00:00:00.0	9.9587	243
56	440.5034	2017-07-09 00:00:00.0	9.9988	243
57	450.5022	2017-07-10 00:00:00.0	9.9988	243
58	460.2981	2017-07-11 00:00:00.0	9.7959	243
59	469.0226	2017-07-12 00:00:00.0	8.7245	243
60	478.1226	2017-07-13 00:00:00.0	9.1000	243
61	488.0078	2017-07-14 00:00:00.0	9.8852	243
62	497.9828	2017-07-15 00:00:00.0	9.9750	243
63	507.9211	2017-07-16 00:00:00.0	9.9383	243
64	517.6791	2017-07-17 00:00:00.0	9.7580	243
65	527.0541	2017-07-18 00:00:00.0	9.3750	243
66	536.3174	2017-07-19 00:00:00.0	9.2633	243
67	546.0924	2017-07-20 00:00:00.0	9.7750	243
68	556.0062	2017-07-21 00:00:00.0	9.9138	243
69	565.5159	2017-07-22 00:00:00.0	9.5097	243
70	575.4649	2017-07-23 00:00:00.0	9.9490	243
71	585.2229	2017-07-24 00:00:00.0	9.7580	243
72	595.2045	2017-07-25 00:00:00.0	9.9816	243
73	605.1632	2017-07-26 00:00:00.0	9.9587	243
74	615.1434	2017-07-27 00:00:00.0	9.9802	243
75	624.5459	2017-07-28 00:00:00.0	9.4025	243
76	633.8348	2017-07-29 00:00:00.0	9.2889	243
77	642.1447	2017-07-30 00:00:00.0	8.3099	243
78	650.3620	2017-07-31 00:00:00.0	8.2173	243
79	660.2885	2017-08-01 00:00:00.0	9.9265	243
80	669.1615	2017-08-02 00:00:00.0	8.8730	243
81	678.4248	2017-08-03 00:00:00.0	9.2633	243
82	687.4814	2017-08-04 00:00:00.0	9.0566	243
83	696.8916	2017-08-05 00:00:00.0	9.4102	243
84	706.6217	2017-08-06 00:00:00.0	9.7301	243
85	716.4743	2017-08-07 00:00:00.0	9.8526	243
86	726.2901	2017-08-08 00:00:00.0	9.8158	243
87	735.4324	2017-08-09 00:00:00.0	9.1423	243
88	745.1625	2017-08-10 00:00:00.0	9.7301	243
89	754.7033	2017-08-11 00:00:00.0	9.5408	243
90	764.6171	2017-08-12 00:00:00.0	9.9138	243
91	774.5554	2017-08-13 00:00:00.0	9.9383	243
92	784.5044	2017-08-14 00:00:00.0	9.9490	243
93	794.4631	2017-08-15 00:00:00.0	9.9587	243
94	804.2978	2017-08-16 00:00:00.0	9.8347	243
95	814.0039	2017-08-17 00:00:00.0	9.7061	243
96	823.9304	2017-08-18 00:00:00.0	9.9265	243
97	833.8069	2017-08-19 00:00:00.0	9.8765	243
98	843.7334	2017-08-20 00:00:00.0	9.9265	243
99	851.0885	2017-08-21 00:00:00.0	7.3551	243
100	858.9987	2017-08-22 00:00:00.0	7.9102	243
101	864.3941	2017-08-23 00:00:00.0	5.3954	243
102	871.4472	2017-08-24 00:00:00.0	7.0531	243
103	880.9248	2017-08-25 00:00:00.0	9.4776	243
104	890.2636	2017-08-26 00:00:00.0	9.3388	243
105	900.1162	2017-08-27 00:00:00.0	9.8526	243
106	910.0718	2017-08-28 00:00:00.0	9.9556	243
107	919.5780	2017-08-29 00:00:00.0	9.5062	243
108	929.1489	2017-08-30 00:00:00.0	9.5709	243
109	938.7770	2017-08-31 00:00:00.0	9.6281	243
110	948.3479	2017-09-01 00:00:00.0	9.5709	243
111	957.7923	2017-09-02 00:00:00.0	9.4444	243
112	966.8923	2017-09-03 00:00:00.0	9.1000	243
113	974.6699	2017-09-04 00:00:00.0	7.7776	243
114	981.6449	2017-09-05 00:00:00.0	6.9750	243
115	987.6036	2017-09-06 00:00:00.0	5.9587	243
116	996.4766	2017-09-07 00:00:00.0	8.8730	243
117	1004.3210	2017-09-08 00:00:00.0	7.8444	243
118	1013.8618	2017-09-09 00:00:00.0	9.5408	243
119	1023.4618	2017-09-10 00:00:00.0	9.6000	243
120	1033.2149	2017-09-11 00:00:00.0	9.7531	243
121	1042.8149	2017-09-12 00:00:00.0	9.6000	243
122	1052.4700	2017-09-13 00:00:00.0	9.6551	243
123	1059.7511	2017-09-14 00:00:00.0	7.2811	243
124	1063.5776	2017-09-15 00:00:00.0	3.8265	243
125	1065.0873	2017-09-16 00:00:00.0	1.5097	243
126	1068.2220	2017-09-17 00:00:00.0	3.1347	243
127	1074.6220	2017-09-18 00:00:00.0	6.4000	243
128	1083.3465	2017-09-19 00:00:00.0	8.7245	243
129	1092.1710	2017-09-20 00:00:00.0	8.8245	243
130	1101.2710	2017-09-21 00:00:00.0	9.1000	243
131	1108.5521	2017-09-22 00:00:00.0	7.2811	243
132	1114.0439	2017-09-23 00:00:00.0	5.4918	243
133	1117.9822	2017-09-24 00:00:00.0	3.9383	243
134	1121.5822	2017-09-25 00:00:00.0	3.6000	243
135	1124.1123	2017-09-26 00:00:00.0	2.5301	243
136	1128.4873	2017-09-27 00:00:00.0	4.3750	243
137	1133.7853	2017-09-28 00:00:00.0	5.2980	243
138	1136.5603	2017-09-29 00:00:00.0	2.7750	243
139	1144.1312	2017-09-30 00:00:00.0	7.5709	243
140	1152.2327	2017-10-01 00:00:00.0	8.1015	243
141	1159.2077	2017-10-02 00:00:00.0	6.9750	243
142	1160.5853	2017-10-03 00:00:00.0	1.3776	243
143	1162.8664	2017-10-04 00:00:00.0	2.2811	243
144	1162.8664	2017-10-05 00:00:00.0	0.0000	243
145	1166.2358	2017-10-06 00:00:00.0	3.3694	243
146	1172.3741	2017-10-07 00:00:00.0	6.1383	243
147	1174.0149	2017-10-08 00:00:00.0	1.6408	243
148	1174.0149	2017-10-09 00:00:00.0	0.0000	243
149	1174.9899	2017-10-10 00:00:00.0	0.9750	243
150	1178.4751	2017-10-11 00:00:00.0	3.4852	243
151	1183.5751	2017-10-12 00:00:00.0	5.1000	243
152	1183.5751	2017-10-13 00:00:00.0	0.0000	243
153	1183.5751	2017-10-14 00:00:00.0	0.0000	243
154	1183.5751	2017-10-15 00:00:00.0	0.0000	243
155	1185.0848	2017-10-16 00:00:00.0	1.5097	243
156	1191.2231	2017-10-17 00:00:00.0	6.1383	243
157	1197.1818	2017-10-18 00:00:00.0	5.9587	243
158	1200.8956	2017-10-19 00:00:00.0	3.7138	243
159	1209.9078	2017-10-20 00:00:00.0	9.0122	243
160	1218.7808	2017-10-21 00:00:00.0	8.8730	243
161	1222.9395	2017-10-22 00:00:00.0	4.1587	243
162	1222.9395	2017-10-23 00:00:00.0	0.0000	243
163	1222.9395	2017-10-24 00:00:00.0	0.0000	243
164	1222.9395	2017-10-25 00:00:00.0	0.0000	243
165	1222.9395	2017-10-26 00:00:00.0	0.0000	243
166	1222.9395	2017-10-27 00:00:00.0	0.0000	243
167	1222.9395	2017-10-28 00:00:00.0	0.0000	243
168	1222.9395	2017-10-29 00:00:00.0	0.0000	243
169	1222.9395	2017-10-30 00:00:00.0	0.0000	243
170	1222.9395	2017-10-31 00:00:00.0	0.0000	243

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1223
10/30/2017	0	1223
10/29/2017	0	1223
10/28/2017	0	1223
10/27/2017	0	1223
10/26/2017	0	1223
10/25/2017	0	1223
10/24/2017	0	1223
10/23/2017	0	1223
10/22/2017	4	1223
10/21/2017	9	1219
10/20/2017	9	1210
10/19/2017	4	1201
10/18/2017	6	1197
10/17/2017	6	1191
10/16/2017	2	1185
10/15/2017	0	1184
10/14/2017	0	1184
10/13/2017	0	1184
10/12/2017	5	1184
10/11/2017	3	1178
10/10/2017	1	1175
10/9/2017	0	1174
10/8/2017	2	1174
10/7/2017	6	1172
10/6/2017	3	1166
10/5/2017	0	1163
10/4/2017	2	1163
10/3/2017	1	1161
10/2/2017	7	1159
10/1/2017	8	1152
9/30/2017	8	1144
9/29/2017	3	1137
9/28/2017	5	1134
9/27/2017	4	1128
9/26/2017	3	1124
9/25/2017	4	1122
9/24/2017	4	1118
9/23/2017	5	1114
9/22/2017	7	1109
9/21/2017	9	1101
9/20/2017	9	1092
9/19/2017	9	1083
9/18/2017	6	1075
9/17/2017	3	1068
9/16/2017	2	1065
9/15/2017	4	1064
9/14/2017	7	1060
9/13/2017	10	1052
9/12/2017	10	1043
9/11/2017	10	1033
9/10/2017	10	1023
9/9/2017	10	1014
9/8/2017	8	1004
9/7/2017	9	996
9/6/2017	6	988
9/5/2017	7	982
9/4/2017	8	975
9/3/2017	9	967
9/2/2017	9	958
9/1/2017	10	948
8/31/2017	10	939
8/30/2017	10	929
8/29/2017	10	920
8/28/2017	10	910
8/27/2017	10	900
8/26/2017	9	890
8/25/2017	9	881
8/24/2017	7	871
8/23/2017	5	864
8/22/2017	8	859
8/21/2017	7	851
8/20/2017	10	844
8/19/2017	10	834
8/18/2017	10	824
8/17/2017	10	814
8/16/2017	10	804
8/15/2017	10	794
8/14/2017	10	785
8/13/2017	10	775
8/12/2017	10	765
8/11/2017	10	755
8/10/2017	10	745
8/9/2017	9	735
8/8/2017	10	726
8/7/2017	10	716
8/6/2017	10	707
8/5/2017	9	697
8/4/2017	9	687
8/3/2017	9	678
8/2/2017	9	669
8/1/2017	10	660
7/31/2017	8	650
7/30/2017	8	642
7/29/2017	9	634
7/28/2017	9	625
7/27/2017	10	615
7/26/2017	10	605
7/25/2017	10	595
7/24/2017	10	585
7/23/2017	10	575
7/22/2017	10	566
7/21/2017	10	556
7/20/2017	10	546
7/19/2017	9	536
7/18/2017	9	527
7/17/2017	10	518
7/16/2017	10	508
7/15/2017	10	498
7/14/2017	10	488
7/13/2017	9	478
7/12/2017	9	469
7/11/2017	10	460
7/10/2017	10	451
7/9/2017	10	441
7/8/2017	10	431
7/7/2017	10	421
7/6/2017	10	411
7/5/2017	10	401
7/4/2017	10	391
7/3/2017	10	381
7/2/2017	9	371
7/1/2017	9	363
6/30/2017	9	354
6/29/2017	10	345
6/28/2017	10	336
6/27/2017	10	326
6/26/2017	8	316
6/25/2017	5	308
6/24/2017	4	303
6/23/2017	7	299
6/22/2017	8	292
6/21/2017	9	284
6/20/2017	9	275
6/19/2017	7	267
6/18/2017	7	259
6/17/2017	7	252
6/16/2017	8	245
6/15/2017	9	237
6/14/2017	9	228
6/13/2017	9	218
6/12/2017	9	209
6/11/2017	10	200
6/10/2017	10	190
6/9/2017	10	180
6/8/2017	10	170
6/7/2017	10	160
6/6/2017	9	150
6/5/2017	10	141
6/4/2017	10	131
6/3/2017	10	121
6/2/2017	8	111
6/1/2017	7	104
5/31/2017	9	97
5/30/2017	6	88
5/29/2017	2	82
5/28/2017	5	80
5/27/2017	8	75
5/26/2017	9	67
5/25/2017	8	58
5/24/2017	8	50
5/23/2017	7	42
5/22/2017	3	34
5/21/2017	2	31
5/20/2017	6	30
5/19/2017	5	24
5/18/2017	1	19
5/17/2017	1	18
5/16/2017	7	17
5/15/2017	9	9

mbpotatoes.ca

Physiological Days