P-Days

query

RESULTSET

query
	ACCUPDAY	DDATE	PDAY	TSTNID
1	9.1423	2017-05-15 00:00:00.0	9.1423	203
2	15.5423	2017-05-16 00:00:00.0	6.4000	203
3	17.4423	2017-05-17 00:00:00.0	1.9000	203
4	17.8663	2017-05-18 00:00:00.0	0.4240	203
5	21.8046	2017-05-19 00:00:00.0	3.9383	203
6	26.9046	2017-05-20 00:00:00.0	5.1000	203
7	28.2822	2017-05-21 00:00:00.0	1.3776	203
8	30.9353	2017-05-22 00:00:00.0	2.6531	203
9	37.9103	2017-05-23 00:00:00.0	6.9750	203
10	46.1940	2017-05-24 00:00:00.0	8.2837	203
11	54.3573	2017-05-25 00:00:00.0	8.1633	203
12	63.0818	2017-05-26 00:00:00.0	8.7245	203
13	71.5384	2017-05-27 00:00:00.0	8.4566	203
14	76.6384	2017-05-28 00:00:00.0	5.1000	203
15	78.7935	2017-05-29 00:00:00.0	2.1551	203
16	84.7522	2017-05-30 00:00:00.0	5.9587	203
17	93.1522	2017-05-31 00:00:00.0	8.4000	203
18	103.1338	2017-06-01 00:00:00.0	9.9816	203
19	111.7894	2017-06-02 00:00:00.0	8.6556	203
20	121.4734	2017-06-03 00:00:00.0	9.6840	203
21	131.2484	2017-06-04 00:00:00.0	9.7750	203
22	141.2402	2017-06-05 00:00:00.0	9.9918	203
23	150.9624	2017-06-06 00:00:00.0	9.7222	203
24	160.8318	2017-06-07 00:00:00.0	9.8694	203
25	170.7456	2017-06-08 00:00:00.0	9.9138	203
26	180.5206	2017-06-09 00:00:00.0	9.7750	203
27	190.4058	2017-06-10 00:00:00.0	9.8852	203
28	200.2910	2017-06-11 00:00:00.0	9.8852	203
29	209.0660	2017-06-12 00:00:00.0	8.7750	203
30	218.0328	2017-06-13 00:00:00.0	8.9668	203
31	227.6037	2017-06-14 00:00:00.0	9.5709	203
32	236.1159	2017-06-15 00:00:00.0	8.5122	203
33	244.5725	2017-06-16 00:00:00.0	8.4566	203
34	252.0725	2017-06-17 00:00:00.0	7.5000	203
35	259.3536	2017-06-18 00:00:00.0	7.2811	203
36	266.9245	2017-06-19 00:00:00.0	7.5709	203
37	275.2668	2017-06-20 00:00:00.0	8.3423	203
38	283.6091	2017-06-21 00:00:00.0	8.3423	203
39	292.0091	2017-06-22 00:00:00.0	8.4000	203
40	298.8249	2017-06-23 00:00:00.0	6.8158	203
41	303.3065	2017-06-24 00:00:00.0	4.4816	203
42	307.8937	2017-06-25 00:00:00.0	4.5872	203
43	315.8039	2017-06-26 00:00:00.0	7.9102	203
44	325.3748	2017-06-27 00:00:00.0	9.5709	203
45	334.7850	2017-06-28 00:00:00.0	9.4102	203
46	343.9687	2017-06-29 00:00:00.0	9.1837	203
47	352.5891	2017-06-30 00:00:00.0	8.6204	203
48	360.9314	2017-07-01 00:00:00.0	8.3423	203
49	368.9702	2017-07-02 00:00:00.0	8.0388	203
50	378.8049	2017-07-03 00:00:00.0	9.8347	203
51	388.4481	2017-07-04 00:00:00.0	9.6432	203
52	398.4283	2017-07-05 00:00:00.0	9.9802	203
53	408.4234	2017-07-06 00:00:00.0	9.9951	203
54	418.0234	2017-07-07 00:00:00.0	9.6000	203
55	427.9372	2017-07-08 00:00:00.0	9.9138	203
56	437.8862	2017-07-09 00:00:00.0	9.9490	203
57	447.8127	2017-07-10 00:00:00.0	9.9265	203
58	457.7617	2017-07-11 00:00:00.0	9.9490	203
59	466.4862	2017-07-12 00:00:00.0	8.7245	203
60	475.1066	2017-07-13 00:00:00.0	8.6204	203
61	484.8367	2017-07-14 00:00:00.0	9.7301	203
62	494.7750	2017-07-15 00:00:00.0	9.9383	203
63	504.6097	2017-07-16 00:00:00.0	9.8347	203
64	514.5097	2017-07-17 00:00:00.0	9.9000	203
65	523.8485	2017-07-18 00:00:00.0	9.3388	203
66	532.9051	2017-07-19 00:00:00.0	9.0566	203
67	542.4760	2017-07-20 00:00:00.0	9.5709	203
68	552.4433	2017-07-21 00:00:00.0	9.9673	203
69	561.8877	2017-07-22 00:00:00.0	9.4444	203
70	571.7224	2017-07-23 00:00:00.0	9.8347	203
71	581.6434	2017-07-24 00:00:00.0	9.9210	203
72	591.6388	2017-07-25 00:00:00.0	9.9954	203
73	601.5975	2017-07-26 00:00:00.0	9.9587	203
74	611.5955	2017-07-27 00:00:00.0	9.9980	203
75	621.4177	2017-07-28 00:00:00.0	9.8222	203
76	630.6461	2017-07-29 00:00:00.0	9.2284	203
77	639.6782	2017-07-30 00:00:00.0	9.0321	203
78	648.1659	2017-07-31 00:00:00.0	8.4877	203
79	658.0006	2017-08-01 00:00:00.0	9.8347	203
80	666.2246	2017-08-02 00:00:00.0	8.2240	203
81	675.0491	2017-08-03 00:00:00.0	8.8245	203
82	683.8241	2017-08-04 00:00:00.0	8.7750	203
83	692.7445	2017-08-05 00:00:00.0	8.9204	203
84	701.7113	2017-08-06 00:00:00.0	8.9668	203
85	711.4863	2017-08-07 00:00:00.0	9.7750	203
86	721.1674	2017-08-08 00:00:00.0	9.6811	203
87	730.3097	2017-08-09 00:00:00.0	9.1423	203
88	739.8505	2017-08-10 00:00:00.0	9.5408	203
89	749.0342	2017-08-11 00:00:00.0	9.1837	203
90	758.6893	2017-08-12 00:00:00.0	9.6551	203
91	768.4852	2017-08-13 00:00:00.0	9.7959	203
92	778.3378	2017-08-14 00:00:00.0	9.8526	203
93	788.2516	2017-08-15 00:00:00.0	9.9138	203
94	797.9577	2017-08-16 00:00:00.0	9.7061	203
95	807.3679	2017-08-17 00:00:00.0	9.4102	203
96	817.2026	2017-08-18 00:00:00.0	9.8347	203
97	826.9606	2017-08-19 00:00:00.0	9.7580	203
98	836.8744	2017-08-20 00:00:00.0	9.9138	203
99	844.7846	2017-08-21 00:00:00.0	7.9102	203
100	852.6948	2017-08-22 00:00:00.0	7.9102	203
101	857.6943	2017-08-23 00:00:00.0	4.9995	203
102	863.9208	2017-08-24 00:00:00.0	6.2265	203
103	873.5759	2017-08-25 00:00:00.0	9.6551	203
104	883.0203	2017-08-26 00:00:00.0	9.4444	203
105	892.8729	2017-08-27 00:00:00.0	9.8526	203
106	902.8124	2017-08-28 00:00:00.0	9.9395	203
107	912.3186	2017-08-29 00:00:00.0	9.5062	203
108	920.8854	2017-08-30 00:00:00.0	8.5668	203
109	930.6155	2017-08-31 00:00:00.0	9.7301	203
110	940.1864	2017-09-01 00:00:00.0	9.5709	203
111	949.5966	2017-09-02 00:00:00.0	9.4102	203
112	959.1063	2017-09-03 00:00:00.0	9.5097	203
113	967.0165	2017-09-04 00:00:00.0	7.9102	203
114	972.9752	2017-09-05 00:00:00.0	5.9587	203
115	977.8732	2017-09-06 00:00:00.0	4.8980	203
116	986.6977	2017-09-07 00:00:00.0	8.8245	203
117	994.5421	2017-09-08 00:00:00.0	7.8444	203
118	1004.1972	2017-09-09 00:00:00.0	9.6551	203
119	1013.7515	2017-09-10 00:00:00.0	9.5543	203
120	1023.6780	2017-09-11 00:00:00.0	9.9265	203
121	1033.0805	2017-09-12 00:00:00.0	9.4025	203
122	1042.5902	2017-09-13 00:00:00.0	9.5097	203
123	1050.0183	2017-09-14 00:00:00.0	7.4281	203
124	1054.1770	2017-09-15 00:00:00.0	4.1587	203
125	1056.2051	2017-09-16 00:00:00.0	2.0281	203
126	1059.8051	2017-09-17 00:00:00.0	3.6000	203
127	1066.8582	2017-09-18 00:00:00.0	7.0531	203
128	1075.7786	2017-09-19 00:00:00.0	8.9204	203

CACHED

false

EXECUTIONTIME

SQL

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

Date	P-Days		Start	End
Date	Daily	Total	Start	End
9/19/2017	9	1076
9/18/2017	7	1067
9/17/2017	4	1060
9/16/2017	2	1056
9/15/2017	4	1054
9/14/2017	7	1050
9/13/2017	10	1043
9/12/2017	9	1033
9/11/2017	10	1024
9/10/2017	10	1014
9/9/2017	10	1004
9/8/2017	8	995
9/7/2017	9	987
9/6/2017	5	978
9/5/2017	6	973
9/4/2017	8	967
9/3/2017	10	959
9/2/2017	9	950
9/1/2017	10	940
8/31/2017	10	931
8/30/2017	9	921
8/29/2017	10	912
8/28/2017	10	903
8/27/2017	10	893
8/26/2017	9	883
8/25/2017	10	874
8/24/2017	6	864
8/23/2017	5	858
8/22/2017	8	853
8/21/2017	8	845
8/20/2017	10	837
8/19/2017	10	827
8/18/2017	10	817
8/17/2017	9	807
8/16/2017	10	798
8/15/2017	10	788
8/14/2017	10	778
8/13/2017	10	768
8/12/2017	10	759
8/11/2017	9	749
8/10/2017	10	740
8/9/2017	9	730
8/8/2017	10	721
8/7/2017	10	711
8/6/2017	9	702
8/5/2017	9	693
8/4/2017	9	684
8/3/2017	9	675
8/2/2017	8	666
8/1/2017	10	658
7/31/2017	8	648
7/30/2017	9	640
7/29/2017	9	631
7/28/2017	10	621
7/27/2017	10	612
7/26/2017	10	602
7/25/2017	10	592
7/24/2017	10	582
7/23/2017	10	572
7/22/2017	9	562
7/21/2017	10	552
7/20/2017	10	542
7/19/2017	9	533
7/18/2017	9	524
7/17/2017	10	515
7/16/2017	10	505
7/15/2017	10	495
7/14/2017	10	485
7/13/2017	9	475
7/12/2017	9	466
7/11/2017	10	458
7/10/2017	10	448
7/9/2017	10	438
7/8/2017	10	428
7/7/2017	10	418
7/6/2017	10	408
7/5/2017	10	398
7/4/2017	10	388
7/3/2017	10	379
7/2/2017	8	369
7/1/2017	8	361
6/30/2017	9	353
6/29/2017	9	344
6/28/2017	9	335
6/27/2017	10	325
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	8	284
6/20/2017	8	275
6/19/2017	8	267
6/18/2017	7	259
6/17/2017	8	252
6/16/2017	8	245
6/15/2017	9	236
6/14/2017	10	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	181
6/8/2017	10	171
6/7/2017	10	161
6/6/2017	10	151
6/5/2017	10	141
6/4/2017	10	131
6/3/2017	10	121
6/2/2017	9	112
6/1/2017	10	103
5/31/2017	8	93
5/30/2017	6	85
5/29/2017	2	79
5/28/2017	5	77
5/27/2017	8	72
5/26/2017	9	63
5/25/2017	8	54
5/24/2017	8	46
5/23/2017	7	38
5/22/2017	3	31
5/21/2017	1	28
5/20/2017	5	27
5/19/2017	4	22
5/18/2017	0	18
5/17/2017	2	17
5/16/2017	6	16
5/15/2017	9	9

mbpotatoes.ca

Physiological Days