P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	9.3388	2017-05-15 00:00:00.0	9.3388	244
2	16.5449	2017-05-16 00:00:00.0	7.2061	244
3	18.5730	2017-05-17 00:00:00.0	2.0281	244
4	19.9506	2017-05-18 00:00:00.0	1.3776	244
5	24.3256	2017-05-19 00:00:00.0	4.3750	244
6	28.5929	2017-05-20 00:00:00.0	4.2673	244
7	29.7031	2017-05-21 00:00:00.0	1.1102	244
8	33.0725	2017-05-22 00:00:00.0	3.3694	244
9	40.1256	2017-05-23 00:00:00.0	7.0531	244
10	48.1006	2017-05-24 00:00:00.0	7.9750	244
11	56.1394	2017-05-25 00:00:00.0	8.0388	244
12	64.1144	2017-05-26 00:00:00.0	7.9750	244
13	72.3981	2017-05-27 00:00:00.0	8.2837	244
14	78.3568	2017-05-28 00:00:00.0	5.9587	244
15	81.3726	2017-05-29 00:00:00.0	3.0158	244
16	87.5109	2017-05-30 00:00:00.0	6.1383	244
17	96.7742	2017-05-31 00:00:00.0	9.2633	244
18	103.9298	2017-06-01 00:00:00.0	7.1556	244
19	112.5026	2017-06-02 00:00:00.0	8.5728	244
20	122.0088	2017-06-03 00:00:00.0	9.5062	244
21	131.9675	2017-06-04 00:00:00.0	9.9587	244
22	141.9070	2017-06-05 00:00:00.0	9.9395	244
23	151.6984	2017-06-06 00:00:00.0	9.7914	244
24	161.6249	2017-06-07 00:00:00.0	9.9265	244
25	171.6244	2017-06-08 00:00:00.0	9.9995	244
26	181.5509	2017-06-09 00:00:00.0	9.9265	244
27	191.5096	2017-06-10 00:00:00.0	9.9587	244
28	201.5076	2017-06-11 00:00:00.0	9.9980	244
29	210.9520	2017-06-12 00:00:00.0	9.4444	244
30	220.1760	2017-06-13 00:00:00.0	9.2240	244
31	229.8311	2017-06-14 00:00:00.0	9.6551	244
32	239.0148	2017-06-15 00:00:00.0	9.1837	244
33	248.4250	2017-06-16 00:00:00.0	9.4102	244
34	256.7673	2017-06-17 00:00:00.0	8.3423	244
35	264.3382	2017-06-18 00:00:00.0	7.5709	244
36	272.8504	2017-06-19 00:00:00.0	8.5122	244
37	281.7234	2017-06-20 00:00:00.0	8.8730	244
38	291.0984	2017-06-21 00:00:00.0	9.3750	244
39	300.1106	2017-06-22 00:00:00.0	9.0122	244
40	307.8882	2017-06-23 00:00:00.0	7.7776	244
41	312.3698	2017-06-24 00:00:00.0	4.4816	244
42	318.3285	2017-06-25 00:00:00.0	5.9587	244
43	326.8953	2017-06-26 00:00:00.0	8.5668	244
44	336.7111	2017-06-27 00:00:00.0	9.8158	244
45	346.2208	2017-06-28 00:00:00.0	9.5097	244
46	355.6652	2017-06-29 00:00:00.0	9.4444	244
47	364.6320	2017-06-30 00:00:00.0	8.9668	244
48	373.4070	2017-07-01 00:00:00.0	8.7750	244
49	382.3274	2017-07-02 00:00:00.0	8.9204	244
50	392.3146	2017-07-03 00:00:00.0	9.9872	244
51	401.2763	2017-07-04 00:00:00.0	8.9617	244
52	410.7319	2017-07-05 00:00:00.0	9.4556	244
53	420.4159	2017-07-06 00:00:00.0	9.6840	244
54	430.2118	2017-07-07 00:00:00.0	9.7959	244
55	440.1920	2017-07-08 00:00:00.0	9.9802	244
56	450.0685	2017-07-09 00:00:00.0	9.8765	244
57	460.0376	2017-07-10 00:00:00.0	9.9691	244
58	470.0364	2017-07-11 00:00:00.0	9.9988	244
59	478.9094	2017-07-12 00:00:00.0	8.8730	244
60	488.0931	2017-07-13 00:00:00.0	9.1837	244
61	498.0196	2017-07-14 00:00:00.0	9.9265	244
62	508.0191	2017-07-15 00:00:00.0	9.9995	244
63	517.9574	2017-07-16 00:00:00.0	9.9383	244
64	527.7796	2017-07-17 00:00:00.0	9.8222	244
65	537.5755	2017-07-18 00:00:00.0	9.7959	244
66	546.7592	2017-07-19 00:00:00.0	9.1837	244
67	556.6730	2017-07-20 00:00:00.0	9.9138	244
68	566.6619	2017-07-21 00:00:00.0	9.9889	244
69	576.4369	2017-07-22 00:00:00.0	9.7750	244
70	586.3956	2017-07-23 00:00:00.0	9.9587	244
71	596.3166	2017-07-24 00:00:00.0	9.9210	244
72	606.2968	2017-07-25 00:00:00.0	9.9802	244
73	616.2963	2017-07-26 00:00:00.0	9.9995	244
74	626.2654	2017-07-27 00:00:00.0	9.9691	244
75	635.8197	2017-07-28 00:00:00.0	9.5543	244
76	645.3259	2017-07-29 00:00:00.0	9.5062	244
77	653.8136	2017-07-30 00:00:00.0	8.4877	244
78	662.0309	2017-07-31 00:00:00.0	8.2173	244
79	672.0181	2017-08-01 00:00:00.0	9.9872	244
80	680.3604	2017-08-02 00:00:00.0	8.3423	244
81	689.5844	2017-08-03 00:00:00.0	9.2240	244
82	698.9946	2017-08-04 00:00:00.0	9.4102	244
83	708.3334	2017-08-05 00:00:00.0	9.3388	244
84	717.6722	2017-08-06 00:00:00.0	9.3388	244
85	727.4472	2017-08-07 00:00:00.0	9.7750	244
86	737.2819	2017-08-08 00:00:00.0	9.8347	244
87	746.5452	2017-08-09 00:00:00.0	9.2633	244
88	756.2753	2017-08-10 00:00:00.0	9.7301	244
89	765.7850	2017-08-11 00:00:00.0	9.5097	244
90	775.5600	2017-08-12 00:00:00.0	9.7750	244
91	785.4126	2017-08-13 00:00:00.0	9.8526	244
92	795.2652	2017-08-14 00:00:00.0	9.8526	244
93	805.0402	2017-08-15 00:00:00.0	9.7750	244
94	814.7933	2017-08-16 00:00:00.0	9.7531	244
95	824.4484	2017-08-17 00:00:00.0	9.6551	244
96	834.3749	2017-08-18 00:00:00.0	9.9265	244
97	844.3305	2017-08-19 00:00:00.0	9.9556	244
98	854.2157	2017-08-20 00:00:00.0	9.8852	244
99	862.4397	2017-08-21 00:00:00.0	8.2240	244
100	871.2642	2017-08-22 00:00:00.0	8.8245	244
101	877.4025	2017-08-23 00:00:00.0	6.1383	244
102	884.9734	2017-08-24 00:00:00.0	7.5709	244
103	894.4510	2017-08-25 00:00:00.0	9.4776	244
104	903.7898	2017-08-26 00:00:00.0	9.3388	244
105	913.5857	2017-08-27 00:00:00.0	9.7959	244
106	923.5808	2017-08-28 00:00:00.0	9.9951	244
107	933.2648	2017-08-29 00:00:00.0	9.6840	244
108	942.4071	2017-08-30 00:00:00.0	9.1423	244
109	951.9479	2017-08-31 00:00:00.0	9.5408	244
110	961.5188	2017-09-01 00:00:00.0	9.5709	244
111	971.1999	2017-09-02 00:00:00.0	9.6811	244
112	980.8810	2017-09-03 00:00:00.0	9.6811	244
113	989.6055	2017-09-04 00:00:00.0	8.7245	244
114	997.0336	2017-09-05 00:00:00.0	7.4281	244
115	1003.0826	2017-09-06 00:00:00.0	6.0490	244
116	1012.3459	2017-09-07 00:00:00.0	9.2633	244
117	1019.8459	2017-09-08 00:00:00.0	7.5000	244
118	1029.2209	2017-09-09 00:00:00.0	9.3750	244
119	1039.0715	2017-09-10 00:00:00.0	9.8506	244
120	1048.9715	2017-09-11 00:00:00.0	9.9000	244
121	1058.6937	2017-09-12 00:00:00.0	9.7222	244
122	1068.3218	2017-09-13 00:00:00.0	9.6281	244
123	1076.2320	2017-09-14 00:00:00.0	7.9102	244
124	1080.4993	2017-09-15 00:00:00.0	4.2673	244
125	1082.5274	2017-09-16 00:00:00.0	2.0281	244
126	1086.1274	2017-09-17 00:00:00.0	3.6000	244
127	1092.0861	2017-09-18 00:00:00.0	5.9587	244
128	1101.0529	2017-09-19 00:00:00.0	8.9668	244
129	1109.8279	2017-09-20 00:00:00.0	8.7750	244
130	1118.8845	2017-09-21 00:00:00.0	9.0566	244
131	1125.8595	2017-09-22 00:00:00.0	6.9750	244
132	1131.4467	2017-09-23 00:00:00.0	5.5872	244
133	1135.2732	2017-09-24 00:00:00.0	3.8265	244
134	1138.8732	2017-09-25 00:00:00.0	3.6000	244
135	1141.1543	2017-09-26 00:00:00.0	2.2811	244
136	1146.3538	2017-09-27 00:00:00.0	5.1995	244
137	1152.0354	2017-09-28 00:00:00.0	5.6816	244
138	1154.1905	2017-09-29 00:00:00.0	2.1551	244
139	1161.2436	2017-09-30 00:00:00.0	7.0531	244
140	1169.1538	2017-10-01 00:00:00.0	7.9102	244
141	1175.9696	2017-10-02 00:00:00.0	6.8158	244
142	1178.2507	2017-10-03 00:00:00.0	2.2811	244
143	1180.5318	2017-10-04 00:00:00.0	2.2811	244
144	1180.5318	2017-10-05 00:00:00.0	0.0000	244
145	1184.3583	2017-10-06 00:00:00.0	3.8265	244
146	1190.7583	2017-10-07 00:00:00.0	6.4000	244
147	1194.3583	2017-10-08 00:00:00.0	3.6000	244
148	1194.3583	2017-10-09 00:00:00.0	0.0000	244
149	1195.0598	2017-10-10 00:00:00.0	0.7015	244
150	1197.0879	2017-10-11 00:00:00.0	2.0281	244
151	1200.9144	2017-10-12 00:00:00.0	3.8265	244
152	1200.9144	2017-10-13 00:00:00.0	0.0000	244
153	1200.9144	2017-10-14 00:00:00.0	0.0000	244
154	1200.9144	2017-10-15 00:00:00.0	0.0000	244
155	1202.5552	2017-10-16 00:00:00.0	1.6408	244
156	1208.5139	2017-10-17 00:00:00.0	5.9587	244
157	1215.1665	2017-10-18 00:00:00.0	6.6526	244
158	1218.1823	2017-10-19 00:00:00.0	3.0158	244
159	1226.3456	2017-10-20 00:00:00.0	8.1633	244
160	1234.6879	2017-10-21 00:00:00.0	8.3423	244
161	1239.2751	2017-10-22 00:00:00.0	4.5872	244
162	1239.2751	2017-10-23 00:00:00.0	0.0000	244
163	1239.2751	2017-10-24 00:00:00.0	0.0000	244
164	1240.6527	2017-10-25 00:00:00.0	1.3776	244
165	1240.6527	2017-10-26 00:00:00.0	0.0000	244
166	1240.6527	2017-10-27 00:00:00.0	0.0000	244
167	1240.6527	2017-10-28 00:00:00.0	0.0000	244
168	1240.6527	2017-10-29 00:00:00.0	0.0000	244
169	1240.6527	2017-10-30 00:00:00.0	0.0000	244
170	1240.6527	2017-10-31 00:00:00.0	0.0000	244

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
10/31/2017	0	1241
10/30/2017	0	1241
10/29/2017	0	1241
10/28/2017	0	1241
10/27/2017	0	1241
10/26/2017	0	1241
10/25/2017	1	1241
10/24/2017	0	1239
10/23/2017	0	1239
10/22/2017	5	1239
10/21/2017	8	1235
10/20/2017	8	1226
10/19/2017	3	1218
10/18/2017	7	1215
10/17/2017	6	1209
10/16/2017	2	1203
10/15/2017	0	1201
10/14/2017	0	1201
10/13/2017	0	1201
10/12/2017	4	1201
10/11/2017	2	1197
10/10/2017	1	1195
10/9/2017	0	1194
10/8/2017	4	1194
10/7/2017	6	1191
10/6/2017	4	1184
10/5/2017	0	1181
10/4/2017	2	1181
10/3/2017	2	1178
10/2/2017	7	1176
10/1/2017	8	1169
9/30/2017	7	1161
9/29/2017	2	1154
9/28/2017	6	1152
9/27/2017	5	1146
9/26/2017	2	1141
9/25/2017	4	1139
9/24/2017	4	1135
9/23/2017	6	1131
9/22/2017	7	1126
9/21/2017	9	1119
9/20/2017	9	1110
9/19/2017	9	1101
9/18/2017	6	1092
9/17/2017	4	1086
9/16/2017	2	1083
9/15/2017	4	1080
9/14/2017	8	1076
9/13/2017	10	1068
9/12/2017	10	1059
9/11/2017	10	1049
9/10/2017	10	1039
9/9/2017	9	1029
9/8/2017	8	1020
9/7/2017	9	1012
9/6/2017	6	1003
9/5/2017	7	997
9/4/2017	9	990
9/3/2017	10	981
9/2/2017	10	971
9/1/2017	10	962
8/31/2017	10	952
8/30/2017	9	942
8/29/2017	10	933
8/28/2017	10	924
8/27/2017	10	914
8/26/2017	9	904
8/25/2017	9	894
8/24/2017	8	885
8/23/2017	6	877
8/22/2017	9	871
8/21/2017	8	862
8/20/2017	10	854
8/19/2017	10	844
8/18/2017	10	834
8/17/2017	10	824
8/16/2017	10	815
8/15/2017	10	805
8/14/2017	10	795
8/13/2017	10	785
8/12/2017	10	776
8/11/2017	10	766
8/10/2017	10	756
8/9/2017	9	747
8/8/2017	10	737
8/7/2017	10	727
8/6/2017	9	718
8/5/2017	9	708
8/4/2017	9	699
8/3/2017	9	690
8/2/2017	8	680
8/1/2017	10	672
7/31/2017	8	662
7/30/2017	8	654
7/29/2017	10	645
7/28/2017	10	636
7/27/2017	10	626
7/26/2017	10	616
7/25/2017	10	606
7/24/2017	10	596
7/23/2017	10	586
7/22/2017	10	576
7/21/2017	10	567
7/20/2017	10	557
7/19/2017	9	547
7/18/2017	10	538
7/17/2017	10	528
7/16/2017	10	518
7/15/2017	10	508
7/14/2017	10	498
7/13/2017	9	488
7/12/2017	9	479
7/11/2017	10	470
7/10/2017	10	460
7/9/2017	10	450
7/8/2017	10	440
7/7/2017	10	430
7/6/2017	10	420
7/5/2017	9	411
7/4/2017	9	401
7/3/2017	10	392
7/2/2017	9	382
7/1/2017	9	373
6/30/2017	9	365
6/29/2017	9	356
6/28/2017	10	346
6/27/2017	10	337
6/26/2017	9	327
6/25/2017	6	318
6/24/2017	4	312
6/23/2017	8	308
6/22/2017	9	300
6/21/2017	9	291
6/20/2017	9	282
6/19/2017	9	273
6/18/2017	8	264
6/17/2017	8	257
6/16/2017	9	248
6/15/2017	9	239
6/14/2017	10	230
6/13/2017	9	220
6/12/2017	9	211
6/11/2017	10	202
6/10/2017	10	192
6/9/2017	10	182
6/8/2017	10	172
6/7/2017	10	162
6/6/2017	10	152
6/5/2017	10	142
6/4/2017	10	132
6/3/2017	10	122
6/2/2017	9	113
6/1/2017	7	104
5/31/2017	9	97
5/30/2017	6	88
5/29/2017	3	81
5/28/2017	6	78
5/27/2017	8	72
5/26/2017	8	64
5/25/2017	8	56
5/24/2017	8	48
5/23/2017	7	40
5/22/2017	3	33
5/21/2017	1	30
5/20/2017	4	29
5/19/2017	4	24
5/18/2017	1	20
5/17/2017	2	19
5/16/2017	7	17
5/15/2017	9	9

mbpotatoes.ca

Physiological Days