P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	9.0566	2017-05-15 00:00:00.0	9.0566	210
2	16.2627	2017-05-16 00:00:00.0	7.2061	210
3	16.9642	2017-05-17 00:00:00.0	0.7015	210
4	16.9642	2017-05-18 00:00:00.0	0.0000	210
5	21.6560	2017-05-19 00:00:00.0	4.6918	210
6	28.3907	2017-05-20 00:00:00.0	6.7347	210
7	30.6718	2017-05-21 00:00:00.0	2.2811	210
8	33.4468	2017-05-22 00:00:00.0	2.7750	210
9	40.4218	2017-05-23 00:00:00.0	6.9750	210
10	48.5233	2017-05-24 00:00:00.0	8.1015	210
11	56.7473	2017-05-25 00:00:00.0	8.2240	210
12	65.4718	2017-05-26 00:00:00.0	8.7245	210
13	73.9284	2017-05-27 00:00:00.0	8.4566	210
14	78.6202	2017-05-28 00:00:00.0	4.6918	210
15	79.5952	2017-05-29 00:00:00.0	0.9750	210
16	84.9906	2017-05-30 00:00:00.0	5.3954	210
17	93.1539	2017-05-31 00:00:00.0	8.1633	210
18	103.1411	2017-06-01 00:00:00.0	9.9872	210
19	111.3584	2017-06-02 00:00:00.0	8.2173	210
20	121.2794	2017-06-03 00:00:00.0	9.9210	210
21	131.1488	2017-06-04 00:00:00.0	9.8694	210
22	141.1044	2017-06-05 00:00:00.0	9.9556	210
23	150.5069	2017-06-06 00:00:00.0	9.4025	210
24	160.2130	2017-06-07 00:00:00.0	9.7061	210
25	170.1395	2017-06-08 00:00:00.0	9.9265	210
26	180.1145	2017-06-09 00:00:00.0	9.9750	210
27	189.9303	2017-06-10 00:00:00.0	9.8158	210
28	199.7461	2017-06-11 00:00:00.0	9.8158	210
29	208.8027	2017-06-12 00:00:00.0	9.0566	210
30	218.3736	2017-06-13 00:00:00.0	9.5709	210
31	227.8180	2017-06-14 00:00:00.0	9.4444	210
32	236.1603	2017-06-15 00:00:00.0	8.3423	210
33	244.1353	2017-06-16 00:00:00.0	7.9750	210
34	251.0312	2017-06-17 00:00:00.0	6.8959	210
35	258.4593	2017-06-18 00:00:00.0	7.4281	210
36	266.2369	2017-06-19 00:00:00.0	7.7776	210
37	275.3369	2017-06-20 00:00:00.0	9.1000	210
38	283.5002	2017-06-21 00:00:00.0	8.1633	210
39	291.6635	2017-06-22 00:00:00.0	8.1633	210
40	298.3161	2017-06-23 00:00:00.0	6.6526	210
41	303.0079	2017-06-24 00:00:00.0	4.6918	210
42	308.9666	2017-06-25 00:00:00.0	5.9587	210
43	317.8396	2017-06-26 00:00:00.0	8.8730	210
44	327.4947	2017-06-27 00:00:00.0	9.6551	210
45	337.0355	2017-06-28 00:00:00.0	9.5408	210
46	346.6064	2017-06-29 00:00:00.0	9.5709	210
47	355.5268	2017-06-30 00:00:00.0	8.9204	210
48	363.8691	2017-07-01 00:00:00.0	8.3423	210
49	372.8359	2017-07-02 00:00:00.0	8.9668	210
50	382.7211	2017-07-03 00:00:00.0	9.8852	210
51	392.6606	2017-07-04 00:00:00.0	9.9395	210
52	402.5371	2017-07-05 00:00:00.0	9.8765	210
53	412.5243	2017-07-06 00:00:00.0	9.9872	210
54	422.2993	2017-07-07 00:00:00.0	9.7750	210
55	432.2580	2017-07-08 00:00:00.0	9.9587	210
56	442.1718	2017-07-09 00:00:00.0	9.9138	210
57	452.1391	2017-07-10 00:00:00.0	9.9673	210
58	461.0595	2017-07-11 00:00:00.0	8.9204	210
59	469.9325	2017-07-12 00:00:00.0	8.8730	210
60	479.2340	2017-07-13 00:00:00.0	9.3015	210
61	489.0866	2017-07-14 00:00:00.0	9.8526	210
62	498.9560	2017-07-15 00:00:00.0	9.8694	210
63	508.7519	2017-07-16 00:00:00.0	9.7959	210
64	518.5099	2017-07-17 00:00:00.0	9.7580	210
65	527.9201	2017-07-18 00:00:00.0	9.4102	210
66	537.2589	2017-07-19 00:00:00.0	9.3388	210
67	546.9140	2017-07-20 00:00:00.0	9.6551	210
68	556.3916	2017-07-21 00:00:00.0	9.4776	210
69	565.9013	2017-07-22 00:00:00.0	9.5097	210
70	575.8396	2017-07-23 00:00:00.0	9.9383	210
71	585.8198	2017-07-24 00:00:00.0	9.9802	210
72	595.8152	2017-07-25 00:00:00.0	9.9954	210
73	605.8106	2017-07-26 00:00:00.0	9.9954	210
74	615.7797	2017-07-27 00:00:00.0	9.9691	210
75	625.5711	2017-07-28 00:00:00.0	9.7914	210
76	634.8600	2017-07-29 00:00:00.0	9.2889	210
77	643.5958	2017-07-30 00:00:00.0	8.7358	210
78	652.4094	2017-07-31 00:00:00.0	8.8136	210
79	662.2441	2017-08-01 00:00:00.0	9.8347	210
80	670.8645	2017-08-02 00:00:00.0	8.6204	210
81	680.0482	2017-08-03 00:00:00.0	9.1837	210
82	689.1482	2017-08-04 00:00:00.0	9.1000	210
83	698.2482	2017-08-05 00:00:00.0	9.1000	210
84	707.7258	2017-08-06 00:00:00.0	9.4776	210
85	717.5217	2017-08-07 00:00:00.0	9.7959	210
86	726.9661	2017-08-08 00:00:00.0	9.4444	210
87	735.8391	2017-08-09 00:00:00.0	8.8730	210
88	745.0631	2017-08-10 00:00:00.0	9.2240	210
89	754.4733	2017-08-11 00:00:00.0	9.4102	210
90	764.1284	2017-08-12 00:00:00.0	9.6551	210
91	773.9034	2017-08-13 00:00:00.0	9.7750	210
92	783.7886	2017-08-14 00:00:00.0	9.8852	210
93	793.6233	2017-08-15 00:00:00.0	9.8347	210
94	803.3294	2017-08-16 00:00:00.0	9.7061	210
95	812.8070	2017-08-17 00:00:00.0	9.4776	210
96	822.6029	2017-08-18 00:00:00.0	9.7959	210
97	832.6029	2017-08-19 00:00:00.0	10.0000	210
98	842.4723	2017-08-20 00:00:00.0	9.8694	210
99	849.8274	2017-08-21 00:00:00.0	7.3551	210
100	857.3274	2017-08-22 00:00:00.0	7.5000	210
101	861.8090	2017-08-23 00:00:00.0	4.4816	210
102	867.8580	2017-08-24 00:00:00.0	6.0490	210
103	877.0003	2017-08-25 00:00:00.0	9.1423	210
104	885.7248	2017-08-26 00:00:00.0	8.7245	210
105	895.4059	2017-08-27 00:00:00.0	9.6811	210
106	905.3977	2017-08-28 00:00:00.0	9.9918	210
107	915.3957	2017-08-29 00:00:00.0	9.9980	210
108	924.0161	2017-08-30 00:00:00.0	8.6204	210
109	933.5870	2017-08-31 00:00:00.0	9.5709	210
110	943.0646	2017-09-01 00:00:00.0	9.4776	210
111	952.5090	2017-09-02 00:00:00.0	9.4444	210
112	961.0758	2017-09-03 00:00:00.0	8.5668	210
113	968.7166	2017-09-04 00:00:00.0	7.6408	210
114	975.1166	2017-09-05 00:00:00.0	6.4000	210
115	980.7038	2017-09-06 00:00:00.0	5.5872	210
116	989.2160	2017-09-07 00:00:00.0	8.5122	210
117	996.8568	2017-09-08 00:00:00.0	7.6408	210
118	1006.3976	2017-09-09 00:00:00.0	9.5408	210
119	1016.1198	2017-09-10 00:00:00.0	9.7222	210
120	1025.9356	2017-09-11 00:00:00.0	9.8158	210
121	1035.8912	2017-09-12 00:00:00.0	9.9556	210
122	1044.9478	2017-09-13 00:00:00.0	9.0566	210
123	1051.1743	2017-09-14 00:00:00.0	6.2265	210
124	1054.8881	2017-09-15 00:00:00.0	3.7138	210
125	1055.9983	2017-09-16 00:00:00.0	1.1102	210
126	1059.0141	2017-09-17 00:00:00.0	3.0158	210
127	1065.4993	2017-09-18 00:00:00.0	6.4852	210
128	1074.0661	2017-09-19 00:00:00.0	8.5668	210
129	1082.7906	2017-09-20 00:00:00.0	8.7245	210
130	1091.1906	2017-09-21 00:00:00.0	8.4000	210
131	1098.0865	2017-09-22 00:00:00.0	6.8959	210
132	1103.6737	2017-09-23 00:00:00.0	5.5872	210
133	1107.5002	2017-09-24 00:00:00.0	3.8265	210
134	1110.1533	2017-09-25 00:00:00.0	2.6531	210
135	1112.4344	2017-09-26 00:00:00.0	2.2811	210
136	1116.1482	2017-09-27 00:00:00.0	3.7138	210
137	1120.1972	2017-09-28 00:00:00.0	4.0490	210
138	1122.7273	2017-09-29 00:00:00.0	2.5301	210
139	1129.9334	2017-09-30 00:00:00.0	7.2061	210
140	1137.9084	2017-10-01 00:00:00.0	7.9750	210
141	1144.8834	2017-10-02 00:00:00.0	6.9750	210
142	1144.8834	2017-10-03 00:00:00.0	0.0000	210
143	1147.0385	2017-10-04 00:00:00.0	2.1551	210
144	1147.0385	2017-10-05 00:00:00.0	0.0000	210
145	1150.0543	2017-10-06 00:00:00.0	3.0158	210
146	1156.1033	2017-10-07 00:00:00.0	6.0490	210
147	1159.1191	2017-10-08 00:00:00.0	3.0158	210
148	1159.1191	2017-10-09 00:00:00.0	0.0000	210
149	1159.1191	2017-10-10 00:00:00.0	0.0000	210
150	1162.3717	2017-10-11 00:00:00.0	3.2526	210
151	1166.9589	2017-10-12 00:00:00.0	4.5872	210
152	1166.9589	2017-10-13 00:00:00.0	0.0000	210
153	1166.9589	2017-10-14 00:00:00.0	0.0000	210
154	1166.9589	2017-10-15 00:00:00.0	0.0000	210
155	1167.7977	2017-10-16 00:00:00.0	0.8388	210
156	1172.5931	2017-10-17 00:00:00.0	4.7954	210
157	1178.7314	2017-10-18 00:00:00.0	6.1383	210
158	1182.2166	2017-10-19 00:00:00.0	3.4852	210
159	1190.8370	2017-10-20 00:00:00.0	8.6204	210
160	1199.8038	2017-10-21 00:00:00.0	8.9668	210
161	1203.7421	2017-10-22 00:00:00.0	3.9383	210
162	1203.7421	2017-10-23 00:00:00.0	0.0000	210
163	1203.7421	2017-10-24 00:00:00.0	0.0000	210
164	1203.7421	2017-10-25 00:00:00.0	0.0000	210
165	1203.7421	2017-10-26 00:00:00.0	0.0000	210
166	1203.7421	2017-10-27 00:00:00.0	0.0000	210
167	1203.7421	2017-10-28 00:00:00.0	0.0000	210
168	1203.7421	2017-10-29 00:00:00.0	0.0000	210
169	1203.7421	2017-10-30 00:00:00.0	0.0000	210
170	1203.7421	2017-10-31 00:00:00.0	0.0000	210

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1204
10/30/2017	0	1204
10/29/2017	0	1204
10/28/2017	0	1204
10/27/2017	0	1204
10/26/2017	0	1204
10/25/2017	0	1204
10/24/2017	0	1204
10/23/2017	0	1204
10/22/2017	4	1204
10/21/2017	9	1200
10/20/2017	9	1191
10/19/2017	3	1182
10/18/2017	6	1179
10/17/2017	5	1173
10/16/2017	1	1168
10/15/2017	0	1167
10/14/2017	0	1167
10/13/2017	0	1167
10/12/2017	5	1167
10/11/2017	3	1162
10/10/2017	0	1159
10/9/2017	0	1159
10/8/2017	3	1159
10/7/2017	6	1156
10/6/2017	3	1150
10/5/2017	0	1147
10/4/2017	2	1147
10/3/2017	0	1145
10/2/2017	7	1145
10/1/2017	8	1138
9/30/2017	7	1130
9/29/2017	3	1123
9/28/2017	4	1120
9/27/2017	4	1116
9/26/2017	2	1112
9/25/2017	3	1110
9/24/2017	4	1108
9/23/2017	6	1104
9/22/2017	7	1098
9/21/2017	8	1091
9/20/2017	9	1083
9/19/2017	9	1074
9/18/2017	6	1065
9/17/2017	3	1059
9/16/2017	1	1056
9/15/2017	4	1055
9/14/2017	6	1051
9/13/2017	9	1045
9/12/2017	10	1036
9/11/2017	10	1026
9/10/2017	10	1016
9/9/2017	10	1006
9/8/2017	8	997
9/7/2017	9	989
9/6/2017	6	981
9/5/2017	6	975
9/4/2017	8	969
9/3/2017	9	961
9/2/2017	9	953
9/1/2017	9	943
8/31/2017	10	934
8/30/2017	9	924
8/29/2017	10	915
8/28/2017	10	905
8/27/2017	10	895
8/26/2017	9	886
8/25/2017	9	877
8/24/2017	6	868
8/23/2017	4	862
8/22/2017	8	857
8/21/2017	7	850
8/20/2017	10	842
8/19/2017	10	833
8/18/2017	10	823
8/17/2017	9	813
8/16/2017	10	803
8/15/2017	10	794
8/14/2017	10	784
8/13/2017	10	774
8/12/2017	10	764
8/11/2017	9	754
8/10/2017	9	745
8/9/2017	9	736
8/8/2017	9	727
8/7/2017	10	718
8/6/2017	9	708
8/5/2017	9	698
8/4/2017	9	689
8/3/2017	9	680
8/2/2017	9	671
8/1/2017	10	662
7/31/2017	9	652
7/30/2017	9	644
7/29/2017	9	635
7/28/2017	10	626
7/27/2017	10	616
7/26/2017	10	606
7/25/2017	10	596
7/24/2017	10	586
7/23/2017	10	576
7/22/2017	10	566
7/21/2017	9	556
7/20/2017	10	547
7/19/2017	9	537
7/18/2017	9	528
7/17/2017	10	519
7/16/2017	10	509
7/15/2017	10	499
7/14/2017	10	489
7/13/2017	9	479
7/12/2017	9	470
7/11/2017	9	461
7/10/2017	10	452
7/9/2017	10	442
7/8/2017	10	432
7/7/2017	10	422
7/6/2017	10	413
7/5/2017	10	403
7/4/2017	10	393
7/3/2017	10	383
7/2/2017	9	373
7/1/2017	8	364
6/30/2017	9	356
6/29/2017	10	347
6/28/2017	10	337
6/27/2017	10	327
6/26/2017	9	318
6/25/2017	6	309
6/24/2017	5	303
6/23/2017	7	298
6/22/2017	8	292
6/21/2017	8	284
6/20/2017	9	275
6/19/2017	8	266
6/18/2017	7	258
6/17/2017	7	251
6/16/2017	8	244
6/15/2017	8	236
6/14/2017	9	228
6/13/2017	10	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	151
6/5/2017	10	141
6/4/2017	10	131
6/3/2017	10	121
6/2/2017	8	111
6/1/2017	10	103
5/31/2017	8	93
5/30/2017	5	85
5/29/2017	1	80
5/28/2017	5	79
5/27/2017	8	74
5/26/2017	9	65
5/25/2017	8	57
5/24/2017	8	49
5/23/2017	7	40
5/22/2017	3	33
5/21/2017	2	31
5/20/2017	7	28
5/19/2017	5	22
5/18/2017	0	17
5/17/2017	1	17
5/16/2017	7	16
5/15/2017	9	9

mbpotatoes.ca

Physiological Days