November 16, 2007 at 7:15 am
Hi,
IDDateValueValues
42007-10-17 00:00:005.1709
372007-10-17 00:00:005.5319
442007-10-17 00:00:005.5793
542007-10-17 00:00:005.2471
552007-10-17 00:00:005.1177
812007-10-17 00:00:005.5510
862007-10-17 00:00:005.5128
962007-10-17 00:00:005.5758
1092007-10-17 00:00:005.4374
1352007-10-17 00:00:005.3585
1462007-10-17 00:00:005.4951
1472007-10-17 00:00:005.5687
1622007-10-17 00:00:005.3626
1942007-10-17 00:00:005.5142
1972007-10-17 00:00:005.3099
2152007-10-17 00:00:005.4673
2492007-10-17 00:00:005.1646
2552007-10-17 00:00:005.4050
2912007-10-17 00:00:005.4025
2922007-10-17 00:00:005.5790
2942007-10-17 00:00:005.5964
3512007-10-17 00:00:005.5525
3592007-10-17 00:00:005.5334
3782007-10-17 00:00:005.4349
3932007-10-17 00:00:005.2422
3962007-10-17 00:00:005.0312
4052007-10-17 00:00:005.3545
4122007-10-17 00:00:005.1772
4252007-10-17 00:00:005.5858
4282007-10-17 00:00:005.4966
4382007-10-17 00:00:005.5761
4452007-10-17 00:00:005.0229
4502007-10-17 00:00:005.5157
4532007-10-17 00:00:005.3058
4742007-10-17 00:00:005.4648
4832007-10-17 00:00:005.4324
4982007-10-17 00:00:005.5982
5322007-10-17 00:00:004.9257
5342007-10-17 00:00:005.5826
5412007-10-17 00:00:005.5702
5532007-10-17 00:00:005.1225
5792007-10-17 00:00:005.4748
5802007-10-17 00:00:004.9339
5922007-10-17 00:00:005.5098
6032007-10-17 00:00:005.5753
6122007-10-17 00:00:005.5890
6202007-10-17 00:00:004.8215
6212007-10-17 00:00:005.4424
6392007-10-17 00:00:005.0394
6472007-10-17 00:00:005.1835
6622007-10-17 00:00:005.5855
6682007-10-17 00:00:005.5657
6712007-10-17 00:00:005.5946
6772007-10-17 00:00:005.3180
6922007-10-17 00:00:005.5788
7072007-10-17 00:00:005.5948
7152007-10-17 00:00:005.1272
7362007-10-17 00:00:005.4100
7432007-10-17 00:00:004.6701
7482007-10-17 00:00:005.5466
7502007-10-17 00:00:005.5929
7692007-10-17 00:00:005.4922
7702007-10-17 00:00:005.5290
7932007-10-17 00:00:005.5966
7972007-10-17 00:00:005.3707
8082007-10-17 00:00:005.2619
8092007-10-17 00:00:005.5909
8192007-10-17 00:00:005.5750
8282007-10-17 00:00:004.8522
8342007-10-17 00:00:004.8318
8382007-10-17 00:00:005.5823
8392007-10-17 00:00:005.4723
8502007-10-17 00:00:005.5888
8532007-10-17 00:00:005.5911
8642007-10-17 00:00:005.4399
8692007-10-17 00:00:005.2521
8812007-10-17 00:00:005.0477
8992007-10-17 00:00:005.5853
9142007-10-17 00:00:005.5755
9172007-10-17 00:00:005.3139
9252007-10-17 00:00:005.1356
9322007-10-17 00:00:005.5785
9482007-10-17 00:00:004.7286
9552007-10-17 00:00:004.9422
9762007-10-17 00:00:005.5496
9772007-10-17 00:00:005.5930
9822007-10-17 00:00:005.5113
10042007-10-17 00:00:005.5481
10062007-10-17 00:00:004.6752
10092007-10-17 00:00:004.8420
10212007-10-17 00:00:005.5820
10312007-10-17 00:00:005.4936
10322007-10-17 00:00:005.5672
10342007-10-17 00:00:005.1320
10392007-10-17 00:00:005.1898
10492007-10-17 00:00:005.3666
10522007-10-17 00:00:005.5967
10702007-10-17 00:00:005.4075
10802007-10-17 00:00:004.8864
10872007-10-17 00:00:005.4698
10962007-10-17 00:00:005.5912
11002007-10-17 00:00:005.5304
11082007-10-17 00:00:005.5949
11222007-10-17 00:00:004.8130
11302007-10-17 00:00:005.2570
11322007-10-17 00:00:005.5908
11482007-10-17 00:00:004.6674
11562007-10-17 00:00:005.5850
11592007-10-17 00:00:005.5932
11732007-10-17 00:00:005.5628
11832007-10-17 00:00:004.8181
11942007-10-17 00:00:005.4877
12012007-10-17 00:00:005.4574
12072007-10-17 00:00:005.4249
12182007-10-17 00:00:005.5815
12502007-10-17 00:00:005.5885
12582007-10-17 00:00:005.5245
12812007-10-17 00:00:005.5970
12922007-10-17 00:00:005.5260
13012007-10-17 00:00:005.5969
13162007-10-17 00:00:005.5906
13232007-10-17 00:00:005.5745
13242007-10-17 00:00:004.7441
13462007-10-17 00:00:005.5782
13502007-10-17 00:00:005.5914
13592007-10-17 00:00:005.5817
13652007-10-17 00:00:005.5951
13822007-10-17 00:00:004.6650
13902007-10-17 00:00:005.5069
14102007-10-17 00:00:005.4549
14122007-10-17 00:00:005.5437
14532007-10-17 00:00:005.4892
14832007-10-17 00:00:005.5952
14962007-10-17 00:00:005.5083
14972007-10-17 00:00:005.5933
15172007-10-17 00:00:005.5882
15412007-10-17 00:00:005.5972
15532007-10-17 00:00:005.5812
15712007-10-17 00:00:005.5643
15782007-10-17 00:00:004.7363
15932007-10-17 00:00:005.5780
16082007-10-17 00:00:005.5915
16232007-10-17 00:00:005.5275
16382007-10-17 00:00:005.5879
16412007-10-17 00:00:005.5905
16582007-10-17 00:00:005.5747
16662007-10-17 00:00:005.5451
16872007-10-17 00:00:005.5935
16922007-10-17 00:00:005.4907
17062007-10-17 00:00:005.5847
17372007-10-17 00:00:005.5809
17402007-10-17 00:00:005.5954
17702007-10-17 00:00:005.5407
17782007-10-17 00:00:005.4000
17802007-10-17 00:00:005.5216
17892007-10-17 00:00:005.2977
17912007-10-17 00:00:005.3504
17942007-10-17 00:00:005.5973
18022007-10-17 00:00:005.5025
18042007-10-17 00:00:005.5903
18602007-10-17 00:00:005.5739
18632007-10-17 00:00:005.4624
18642007-10-17 00:00:005.5917
18882007-10-17 00:00:005.4299
18982007-10-17 00:00:005.2373
19152007-10-17 00:00:005.4848
19192007-10-17 00:00:005.5877
19232007-10-17 00:00:005.5039
19752007-10-17 00:00:005.5844
20022007-10-17 00:00:005.3018
20122007-10-17 00:00:005.5584
20202007-10-17 00:00:005.5777
20282007-10-17 00:00:005.5936
20422007-10-17 00:00:005.5422
20692007-10-17 00:00:005.5975
20842007-10-17 00:00:005.5807
21032007-10-17 00:00:005.5772
21082007-10-17 00:00:005.5613
21212007-10-17 00:00:005.4863
21232007-10-17 00:00:005.5231
21252007-10-17 00:00:005.3975
21332007-10-17 00:00:005.4599
21392007-10-17 00:00:005.5918
21602007-10-17 00:00:005.5902
21682007-10-17 00:00:005.5955
21892007-10-17 00:00:005.5742
22102007-10-17 00:00:005.3950
22172007-10-17 00:00:005.5938
22312007-10-17 00:00:005.5842
22812007-10-17 00:00:005.5599
22822007-10-17 00:00:005.5774
23032007-10-17 00:00:005.4274
23072007-10-17 00:00:005.3464
23252007-10-17 00:00:005.5054
23302007-10-17 00:00:005.5874
23422007-10-17 00:00:005.2926
23462007-10-17 00:00:005.5900
23562007-10-17 00:00:005.1509
23652007-10-17 00:00:005.5769
23952007-10-17 00:00:005.5734
23992007-10-17 00:00:005.5920
24092007-10-17 00:00:004.9886
24102007-10-17 00:00:004.8821
24242007-10-17 00:00:005.0950
24272007-10-17 00:00:005.5554
24282007-10-17 00:00:004.7714
24292007-10-17 00:00:005.5957
24582007-10-17 00:00:005.5836
24782007-10-17 00:00:004.7151
24832007-10-17 00:00:005.2257
25042007-10-17 00:00:004.6803
25062007-10-17 00:00:005.5839
25582007-10-17 00:00:005.5958
25682007-10-17 00:00:005.5939
25742007-10-17 00:00:004.8913
25802007-10-17 00:00:005.5804
25982007-10-17 00:00:005.5871
26092007-10-17 00:00:005.5976
26242007-10-17 00:00:005.5731
26312007-10-17 00:00:005.1549
26572007-10-17 00:00:005.5921
26612007-10-17 00:00:004.9961
26732007-10-17 00:00:005.2874
26752007-10-17 00:00:005.5899
26862007-10-17 00:00:004.7675
26912007-10-17 00:00:005.1026
26922007-10-17 00:00:005.5869
27042007-10-17 00:00:005.5941
27052007-10-17 00:00:005.5393
27112007-10-17 00:00:005.5834
27242007-10-17 00:00:005.5736
27332007-10-17 00:00:004.7296
27382007-10-17 00:00:005.2315
27542007-10-17 00:00:005.3909
27802007-10-17 00:00:005.5766
28022007-10-17 00:00:005.5960
28072007-10-17 00:00:005.5569
28122007-10-17 00:00:005.1581
28162007-10-17 00:00:005.5378
28282007-10-17 00:00:004.6762
28612007-10-17 00:00:004.7441
28662007-10-17 00:00:005.3423
28732007-10-17 00:00:005.5978
28832007-10-17 00:00:005.5898
29052007-10-17 00:00:005.1960
29122007-10-17 00:00:004.9004
29192007-10-17 00:00:005.5801
29212007-10-17 00:00:005.5923
29292007-10-17 00:00:005.5201
29512007-10-17 00:00:004.7636
29522007-10-17 00:00:005.1101
29592007-10-17 00:00:005.5866
29762007-10-17 00:00:005.5831
30312007-10-17 00:00:004.6722
30382007-10-17 00:00:005.5796
30642007-10-17 00:00:005.5942
30842007-10-17 00:00:005.0050
31012007-10-17 00:00:004.9088
31142007-10-17 00:00:005.5799
31342007-10-17 00:00:004.7688
31372007-10-17 00:00:005.5979
31392007-10-17 00:00:005.5763
31582007-10-17 00:00:005.1614
31672007-10-17 00:00:005.2228
31812007-10-17 00:00:005.5924
32202007-10-17 00:00:004.7597
32302007-10-17 00:00:005.5896
32422007-10-17 00:00:005.5961
32882007-10-17 00:00:005.5943
33612007-10-17 00:00:005.0140
33812007-10-17 00:00:004.6698
33942007-10-17 00:00:005.5863
34052007-10-17 00:00:004.9867
34112007-10-17 00:00:005.5981
34262007-10-17 00:00:005.5895
34602007-10-17 00:00:004.9173
34612007-10-17 00:00:005.1764
34632007-10-17 00:00:005.5926
34662007-10-17 00:00:005.5861
34892007-10-17 00:00:004.7519
35072007-10-17 00:00:005.5963
35492007-10-17 00:00:004.7934
35562007-10-17 00:00:005.5828
35772007-10-17 00:00:005.3788
35992007-10-17 00:00:005.5010
36042007-10-17 00:00:005.3261
36222007-10-17 00:00:005.5945
36282007-10-17 00:00:004.9504
36292007-10-17 00:00:005.4798
36592007-10-17 00:00:005.5893
36682007-10-17 00:00:005.4175
36752007-10-17 00:00:005.1393
37002007-10-17 00:00:004.7210
37232007-10-17 00:00:005.5927
37272007-10-17 00:00:005.1961
37442007-10-17 00:00:005.2720
37742007-10-17 00:00:004.9582
37782007-10-17 00:00:004.8523
37812007-10-17 00:00:004.9205
38122007-10-17 00:00:004.8045
38162007-10-17 00:00:005.3301
38292007-10-17 00:00:004.6803
38392007-10-17 00:00:005.4474
38422007-10-17 00:00:005.0558
38562007-10-17 00:00:005.1429
38592007-10-17 00:00:005.3220
38902007-10-17 00:00:004.7133
38962007-10-17 00:00:005.4773
39602007-10-17 00:00:004.8592
39732007-10-17 00:00:005.0139
39992007-10-17 00:00:005.4150
40012007-10-17 00:00:005.4125
40142007-10-17 00:00:004.9659
40212007-10-17 00:00:004.9672
40512007-10-17 00:00:004.7960
40562007-10-17 00:00:005.2668
40822007-10-17 00:00:004.6871
40942007-10-17 00:00:005.0640
40972007-10-17 00:00:005.4449
41282007-10-17 00:00:005.2024
41382007-10-17 00:00:005.3747
41702007-10-17 00:00:005.5540
41732007-10-17 00:00:005.4224
41802007-10-17 00:00:005.1469
41932007-10-17 00:00:005.2140
41972007-10-17 00:00:004.6938
42082007-10-17 00:00:004.7036
42142007-10-17 00:00:005.2823
42202007-10-17 00:00:005.0606
42272007-10-17 00:00:005.3869
42382007-10-17 00:00:005.4980
42402007-10-17 00:00:005.5348
42782007-10-17 00:00:004.8661
42952007-10-17 00:00:004.7878
43122007-10-17 00:00:005.3382
43342007-10-17 00:00:005.4524
43392007-10-17 00:00:005.0721
43512007-10-17 00:00:005.5716
43532007-10-17 00:00:004.6940
43752007-10-17 00:00:005.2082
44032007-10-17 00:00:004.9737
44092007-10-17 00:00:005.5172
44492007-10-17 00:00:005.2199
44572007-10-17 00:00:004.7006
44592007-10-17 00:00:004.8730
44762007-10-17 00:00:005.3828
44792007-10-17 00:00:005.1057
45022007-10-17 00:00:005.4199
45062007-10-17 00:00:005.4995
45452007-10-17 00:00:005.4823
45462007-10-17 00:00:005.2771
45532007-10-17 00:00:005.0874
45592007-10-17 00:00:004.7796
45682007-10-17 00:00:005.5363
45992007-10-17 00:00:005.0797
46022007-10-17 00:00:005.4499
46502007-10-17 00:00:004.9812
46572007-10-17 00:00:005.5186
46692007-10-17 00:00:005.1509
46772007-10-17 00:00:004.6843
47072007-10-17 00:00:005.3342
153762007-10-17 00:00:005.5982
153772007-10-17 00:00:005.5982
153782007-10-17 00:00:005.5982
153792007-10-17 00:00:005.5982
153802007-10-17 00:00:005.5982
153812007-10-17 00:00:005.5982
153822007-10-17 00:00:005.5982
153832007-10-17 00:00:005.5982
153842007-10-17 00:00:005.5982
153852007-10-17 00:00:005.5982
153862007-10-17 00:00:005.5982
153872007-10-17 00:00:005.5982
153882007-10-17 00:00:005.5982
153892007-10-17 00:00:005.5982
153902007-10-17 00:00:005.5982
153912007-10-17 00:00:005.5982
153922007-10-17 00:00:005.5982
153932007-10-17 00:00:005.5982
153942007-10-17 00:00:005.5982
153952007-10-17 00:00:005.5982
153962007-10-17 00:00:005.5982
153972007-10-17 00:00:005.5982
153982007-10-17 00:00:005.5982
153992007-10-17 00:00:005.5982
154002007-10-17 00:00:005.5982
154012007-10-17 00:00:005.5982
154022007-10-17 00:00:005.5982
154032007-10-17 00:00:005.5982
154042007-10-17 00:00:005.5982
154052007-10-17 00:00:005.5982
154062007-10-17 00:00:005.5982
154072007-10-17 00:00:005.5982
154082007-10-17 00:00:005.5982
154092007-10-17 00:00:005.5982
154102007-10-17 00:00:005.5982
154112007-10-17 00:00:005.5982
154122007-10-17 00:00:005.5982
154132007-10-17 00:00:005.5982
154142007-10-17 00:00:005.5982
154152007-10-17 00:00:005.5982
154162007-10-17 00:00:005.5982
154172007-10-17 00:00:005.5982
154182007-10-17 00:00:005.5982
154192007-10-17 00:00:005.5982
154202007-10-17 00:00:005.5982
154212007-10-17 00:00:005.5982
154222007-10-17 00:00:005.5982
154232007-10-17 00:00:005.5982
154242007-10-17 00:00:005.5982
154252007-10-17 00:00:005.5982
154262007-10-17 00:00:005.5982
154272007-10-17 00:00:005.5982
154282007-10-17 00:00:005.5982
154292007-10-17 00:00:005.5982
154302007-10-17 00:00:005.5982
154312007-10-17 00:00:005.5982
154322007-10-17 00:00:005.5982
154332007-10-17 00:00:005.5982
154342007-10-17 00:00:005.5982
154352007-10-17 00:00:005.5982
154362007-10-17 00:00:005.5982
154372007-10-17 00:00:005.5982
154382007-10-17 00:00:005.5982
154392007-10-17 00:00:005.5982
154402007-10-17 00:00:005.5982
154412007-10-17 00:00:005.5982
154422007-10-17 00:00:005.5982
154432007-10-17 00:00:005.5982
154442007-10-17 00:00:005.5982
154452007-10-17 00:00:005.5982
154462007-10-17 00:00:005.5982
154472007-10-17 00:00:005.5982
154482007-10-17 00:00:005.5982
154492007-10-17 00:00:005.5982
154502007-10-17 00:00:005.5982
154512007-10-17 00:00:005.5982
154522007-10-17 00:00:005.5982
154532007-10-17 00:00:005.5982
154542007-10-17 00:00:005.5982
154552007-10-17 00:00:005.5982
154562007-10-17 00:00:005.5982
154572007-10-17 00:00:005.5982
154582007-10-17 00:00:005.5982
154592007-10-17 00:00:005.5982
154602007-10-17 00:00:005.5982
154612007-10-17 00:00:005.5982
154622007-10-17 00:00:005.5982
154632007-10-17 00:00:005.5982
154642007-10-17 00:00:005.5982
154652007-10-17 00:00:005.5982
154662007-10-17 00:00:005.5982
154672007-10-17 00:00:005.5982
154682007-10-17 00:00:005.5982
154692007-10-17 00:00:005.5982
154702007-10-17 00:00:005.5982
154712007-10-17 00:00:005.5982
154722007-10-17 00:00:005.5982
154732007-10-17 00:00:005.5982
154742007-10-17 00:00:005.5982
154752007-10-17 00:00:005.5982
154762007-10-17 00:00:005.5982
154772007-10-17 00:00:005.5982
154782007-10-17 00:00:005.5982
154792007-10-17 00:00:005.5982
154802007-10-17 00:00:005.5982
154812007-10-17 00:00:005.5982
154822007-10-17 00:00:005.5982
154832007-10-17 00:00:005.5982
154842007-10-17 00:00:005.5982
154852007-10-17 00:00:005.5982
154862007-10-17 00:00:005.5982
154872007-10-17 00:00:005.5982
154882007-10-17 00:00:005.5982
154892007-10-17 00:00:005.5982
154902007-10-17 00:00:005.5982
154912007-10-17 00:00:005.5982
154922007-10-17 00:00:005.5982
154932007-10-17 00:00:005.5982
154942007-10-17 00:00:005.5982
154952007-10-17 00:00:005.5982
154962007-10-17 00:00:005.5982
154972007-10-17 00:00:005.5982
154982007-10-17 00:00:005.5982
154992007-10-17 00:00:005.5982
155002007-10-17 00:00:005.5982
155012007-10-17 00:00:005.5982
155022007-10-17 00:00:005.5982
155032007-10-17 00:00:005.5982
155042007-10-17 00:00:005.5982
155052007-10-17 00:00:005.5982
155062007-10-17 00:00:005.5982
155072007-10-17 00:00:005.5982
155082007-10-17 00:00:005.5982
155092007-10-17 00:00:005.5982
155102007-10-17 00:00:005.5982
155112007-10-17 00:00:005.5982
155122007-10-17 00:00:005.5982
155132007-10-17 00:00:005.5982
155142007-10-17 00:00:005.5982
155152007-10-17 00:00:005.5982
155162007-10-17 00:00:005.5982
155172007-10-17 00:00:005.5982
155182007-10-17 00:00:005.5982
155192007-10-17 00:00:005.5982
155202007-10-17 00:00:005.5982
155212007-10-17 00:00:005.5982
155222007-10-17 00:00:005.5982
155232007-10-17 00:00:005.5982
155242007-10-17 00:00:005.5982
155252007-10-17 00:00:005.5982
155262007-10-17 00:00:005.5982
155272007-10-17 00:00:005.5982
155282007-10-17 00:00:005.5982
155292007-10-17 00:00:005.5982
155302007-10-17 00:00:005.5982
155312007-10-17 00:00:005.5982
155322007-10-17 00:00:005.5982
155332007-10-17 00:00:005.5982
155342007-10-17 00:00:005.5982
155352007-10-17 00:00:005.5982
155362007-10-17 00:00:005.5982
155372007-10-17 00:00:005.5982
155382007-10-17 00:00:005.5982
155392007-10-17 00:00:005.5982
155402007-10-17 00:00:005.5982
155412007-10-17 00:00:005.5982
155422007-10-17 00:00:005.5982
155432007-10-17 00:00:005.5982
155442007-10-17 00:00:005.5982
155452007-10-17 00:00:005.5982
155462007-10-17 00:00:005.5982
155472007-10-17 00:00:005.5982
155482007-10-17 00:00:005.5982
155492007-10-17 00:00:005.5982
155502007-10-17 00:00:005.5982
155512007-10-17 00:00:005.5982
155522007-10-17 00:00:005.5982
155532007-10-17 00:00:005.5982
155542007-10-17 00:00:005.5982
155552007-10-17 00:00:005.5982
155562007-10-17 00:00:005.5982
155572007-10-17 00:00:005.5982
155582007-10-17 00:00:005.5982
155592007-10-17 00:00:005.5982
155602007-10-17 00:00:005.5982
155612007-10-17 00:00:005.5982
155622007-10-17 00:00:005.5982
155632007-10-17 00:00:005.5982
155642007-10-17 00:00:005.5982
155652007-10-17 00:00:005.5982
155662007-10-17 00:00:005.5982
155672007-10-17 00:00:005.5982
155682007-10-17 00:00:005.5982
155692007-10-17 00:00:005.5982
155702007-10-17 00:00:005.5982
155712007-10-17 00:00:005.5982
155722007-10-17 00:00:005.5982
155732007-10-17 00:00:005.5982
155742007-10-17 00:00:005.5982
155752007-10-17 00:00:005.5982
155762007-10-17 00:00:005.5982
155772007-10-17 00:00:005.5982
155782007-10-17 00:00:005.5982
155792007-10-17 00:00:005.5982
155802007-10-17 00:00:005.5982
155812007-10-17 00:00:005.5982
155822007-10-17 00:00:005.5982
155832007-10-17 00:00:005.5982
155842007-10-17 00:00:005.5982
155852007-10-17 00:00:005.5982
155862007-10-17 00:00:005.5982
155872007-10-17 00:00:005.5982
155882007-10-17 00:00:005.5982
155892007-10-17 00:00:005.5982
155902007-10-17 00:00:005.5982
155912007-10-17 00:00:005.5982
155922007-10-17 00:00:005.5982
155932007-10-17 00:00:005.5982
155942007-10-17 00:00:005.5982
155952007-10-17 00:00:005.5982
155962007-10-17 00:00:005.5982
155972007-10-17 00:00:005.5982
155982007-10-17 00:00:005.5982
155992007-10-17 00:00:005.5982
156002007-10-17 00:00:005.5982
156012007-10-17 00:00:005.5982
156022007-10-17 00:00:005.5982
156032007-10-17 00:00:005.5982
156042007-10-17 00:00:005.5982
156052007-10-17 00:00:005.5982
156062007-10-17 00:00:005.5982
156072007-10-17 00:00:005.5982
156082007-10-17 00:00:005.5982
156092007-10-17 00:00:005.5982
156102007-10-17 00:00:005.5982
156112007-10-17 00:00:005.5982
156122007-10-17 00:00:005.5982
156132007-10-17 00:00:005.5982
156142007-10-17 00:00:005.5982
156152007-10-17 00:00:005.5982
I need to find last same value rows from SQL querry
November 16, 2007 at 7:49 am
There is small correction in the data and I need find min Yearvalue from there onwards value become -stagnant
IDDateValueValueYearValueMonthvalue
340517/10/20074.986700
346117/10/20075.176401
316717/10/20075.222802
290517/10/20075.19603
235617/10/20075.150904
447917/10/20075.105705
422017/10/20075.060606
397317/10/20075.013907
402117/10/20074.967208
378117/10/20074.920509
108017/10/20074.8864010
82817/10/20074.8522011
118317/10/20074.818110
354917/10/20074.793411
313417/10/20074.768812
286117/10/20074.744113
273317/10/20074.729614
247817/10/20074.715115
445717/10/20074.700616
419717/10/20074.693817
408217/10/20074.687118
382917/10/20074.680319
100617/10/20074.6752110
74317/10/20074.6701111
138217/10/20074.66520
114817/10/20074.667421
338117/10/20074.669822
303117/10/20074.672223
282817/10/20074.676224
250417/10/20074.680325
467717/10/20074.684326
435317/10/20074.69427
420817/10/20074.703628
389017/10/20074.713329
370017/10/20074.721210
94817/10/20074.7286211
157817/10/20074.736330
132417/10/20074.744131
348917/10/20074.751932
322017/10/20074.759733
295117/10/20074.763634
268617/10/20074.767535
242817/10/20074.771436
455917/10/20074.779637
429517/10/20074.787838
405117/10/20074.79639
381217/10/20074.8045310
112217/10/20074.813311
62017/10/20074.821540
83417/10/20074.831841
100917/10/20074.84242
377817/10/20074.852343
396017/10/20074.859244
427817/10/20074.866145
445917/10/20074.87346
241017/10/20074.882147
257417/10/20074.891348
291217/10/20074.900449
310117/10/20074.9088410
346017/10/20074.9173411
53217/10/20074.925750
58017/10/20074.933951
95517/10/20074.942252
362817/10/20074.950453
377417/10/20074.958254
401417/10/20074.965955
440317/10/20074.973756
465017/10/20074.981257
240917/10/20074.988658
266117/10/20074.996159
308417/10/20075.005510
336117/10/20075.014511
44517/10/20075.022960
39617/10/20075.031261
63917/10/20075.039462
88117/10/20075.047763
384217/10/20075.055864
409417/10/20075.06465
433917/10/20075.072166
459917/10/20075.079767
455317/10/20075.087468
242417/10/20075.09569
269117/10/20075.1026610
295217/10/20075.1101611
5517/10/20075.117770
55317/10/20075.122571
71517/10/20075.127272
103417/10/20075.13273
92517/10/20075.135674
367517/10/20075.139375
385617/10/20075.142976
418017/10/20075.146977
466917/10/20075.150978
263117/10/20075.154979
281217/10/20075.1581710
315817/10/20075.1614711
24917/10/20075.164680
417/10/20075.170981
41217/10/20075.177282
64717/10/20075.183583
103917/10/20075.189884
372717/10/20075.196185
412817/10/20075.202486
437517/10/20075.208287
419317/10/20075.21488
444917/10/20075.219989
248317/10/20075.2257810
273817/10/20075.2315811
189817/10/20075.237390
39317/10/20075.242291
5417/10/20075.247192
86917/10/20075.252193
113017/10/20075.25794
80817/10/20075.261995
405617/10/20075.266896
374417/10/20075.27297
454617/10/20075.277198
421417/10/20075.282399
267317/10/20075.2874910
234217/10/20075.2926911
178917/10/20075.2977100
200217/10/20075.3018101
45317/10/20075.3058102
19717/10/20075.3099103
91717/10/20075.3139104
67717/10/20075.318105
385917/10/20075.322106
360417/10/20075.3261107
381617/10/20075.3301108
470717/10/20075.3342109
431217/10/20075.33821010
286617/10/20075.34231011
230717/10/20075.3464110
179117/10/20075.3504111
40517/10/20075.3545112
13517/10/20075.3585113
16217/10/20075.3626114
104917/10/20075.3666115
79717/10/20075.3707116
413817/10/20075.3747117
357717/10/20075.3788118
447617/10/20075.3828119
422717/10/20075.38691110
275417/10/20075.39091111
221017/10/20075.395120
212517/10/20075.3975121
177817/10/20075.4122
29117/10/20075.4025123
25517/10/20075.405124
107017/10/20075.4075125
73617/10/20075.41126
400117/10/20075.4125127
399917/10/20075.415128
366817/10/20075.4175129
450217/10/20075.41991210
417317/10/20075.42241211
120717/10/20075.4249130
230317/10/20075.4274131
188817/10/20075.4299132
48317/10/20075.4324133
37817/10/20075.4349134
10917/10/20075.4374135
86417/10/20075.4399136
62117/10/20075.4424137
409717/10/20075.4449138
383917/10/20075.4474139
460217/10/20075.44991310
433417/10/20075.45241311
141017/10/20075.4549140
120117/10/20075.4574141
213317/10/20075.4599142
186317/10/20075.4624143
47417/10/20075.4648144
21517/10/20075.4673145
108717/10/20075.4698146
83917/10/20075.4723147
57917/10/20075.4748148
389617/10/20075.4773149
362917/10/20075.47981410
454517/10/20075.48231411
191517/10/20075.4848150
212117/10/20075.4863151
119417/10/20075.4877152
145317/10/20075.4892153
169217/10/20075.4907154
76917/10/20075.4922155
103117/10/20075.4936156
14617/10/20075.4951157
42817/10/20075.4966158
423817/10/20075.498159
450617/10/20075.49951510
359917/10/20075.5011511
180217/10/20075.5025160
192317/10/20075.5039161
232517/10/20075.5054162
139017/10/20075.5069163
149617/10/20075.5083164
59217/10/20075.5098165
98217/10/20075.5113166
8617/10/20075.5128167
19417/10/20075.5142168
45017/10/20075.5157169
440917/10/20075.51721610
465717/10/20075.51861611
292917/10/20075.5201170
178017/10/20075.5216171
212317/10/20075.5231172
125817/10/20075.5245173
129217/10/20075.526174
162317/10/20075.5275175
77017/10/20075.529176
110017/10/20075.5304177
3717/10/20075.5319178
35917/10/20075.5334179
424017/10/20075.53481710
456817/10/20075.53631711
281617/10/20075.5378180
270517/10/20075.5393181
177017/10/20075.5407182
204217/10/20075.5422183
141217/10/20075.5437184
166617/10/20075.5451185
74817/10/20075.5466186
100417/10/20075.5481187
97617/10/20075.5496188
8117/10/20075.551189
35117/10/20075.55251810
417017/10/20075.5541811
242717/10/20075.5554190
280717/10/20075.5569191
201217/10/20075.5584192
228117/10/20075.5599193
210817/10/20075.5613194
117317/10/20075.5628195
157117/10/20075.5643196
66817/10/20075.5657197
103217/10/20075.5672198
14717/10/20075.5687199
54117/10/20075.57021910
435117/10/20075.57161911
262417/10/20075.5731200
239517/10/20075.5734201
272417/10/20075.5736202
186017/10/20075.5739203
218917/10/20075.5742204
132317/10/20075.5745205
165817/10/20075.5747206
81917/10/20075.575207
60317/10/20075.5753208
91417/10/20075.5755209
9617/10/20075.57582010
43817/10/20075.57612011
313917/10/20075.5763210
278017/10/20075.5766211
236517/10/20075.5769212
210317/10/20075.5772213
228217/10/20075.5774214
202017/10/20075.5777215
159317/10/20075.578216
134617/10/20075.5782217
93217/10/20075.5785218
69217/10/20075.5788219
29217/10/20075.5792110
4417/10/20075.57932111
303817/10/20075.5796220
311417/10/20075.5799221
291917/10/20075.5801222
258017/10/20075.5804223
208417/10/20075.5807224
173717/10/20075.5809225
155317/10/20075.5812226
121817/10/20075.5815227
135917/10/20075.5817228
102117/10/20075.582229
83817/10/20075.58232210
53417/10/20075.58262211
355617/10/20075.5828230
297617/10/20075.5831231
271117/10/20075.5834232
245817/10/20075.5836233
250617/10/20075.5839234
223117/10/20075.5842235
197517/10/20075.5844236
170617/10/20075.5847237
115617/10/20075.585238
89917/10/20075.5853239
66217/10/20075.58552310
42517/10/20075.58582311
346617/10/20075.5861240
339417/10/20075.5863241
295917/10/20075.5866242
269217/10/20075.5869243
259817/10/20075.5871244
233017/10/20075.5874245
191917/10/20075.5877246
163817/10/20075.5879247
151717/10/20075.5882248
125017/10/20075.5885249
85017/10/20075.58882410
61217/10/20075.5892411
365917/10/20075.5893250
342617/10/20075.5895251
323017/10/20075.5896252
288317/10/20075.5898253
267517/10/20075.5899254
234617/10/20075.59255
216017/10/20075.5902256
180417/10/20075.5903257
164117/10/20075.5905258
131617/10/20075.5906259
113217/10/20075.59082510
80917/10/20075.59092511
85317/10/20075.5911260
109617/10/20075.5912261
135017/10/20075.5914262
160817/10/20075.5915263
186417/10/20075.5917264
213917/10/20075.5918265
239917/10/20075.592266
265717/10/20075.5921267
292117/10/20075.5923268
318117/10/20075.5924269
346317/10/20075.59262610
372317/10/20075.59272611
75017/10/20075.5929270
97717/10/20075.593271
115917/10/20075.5932272
149717/10/20075.5933273
168717/10/20075.5935274
202817/10/20075.5936275
221717/10/20075.5938276
256817/10/20075.5939277
270417/10/20075.5941278
306417/10/20075.5942279
328817/10/20075.59432710
362217/10/20075.59452711
67117/10/20075.5946280
70717/10/20075.5948281
110817/10/20075.5949282
136517/10/20075.5951283
148317/10/20075.5952284
174017/10/20075.5954285
216817/10/20075.5955286
242917/10/20075.5957287
255817/10/20075.5958288
280217/10/20075.596289
324217/10/20075.59612810
350717/10/20075.59632811
29417/10/20075.5964290
79317/10/20075.5966291
105217/10/20075.5967292
130117/10/20075.5969293
128117/10/20075.597294
154117/10/20075.5972295
179417/10/20075.5973296
206917/10/20075.5975297
260917/10/20075.5976298
287317/10/20075.5978299
313717/10/20075.59792910
341117/10/20075.59812911
49817/10/20075.5982300
1537617/10/20075.5982301
1537717/10/20075.5982302
1537817/10/20075.5982303
1537917/10/20075.5982304
1538017/10/20075.5982305
1538117/10/20075.5982306
1538217/10/20075.5982307
1538317/10/20075.5982308
1538417/10/20075.5982309
1538517/10/20075.59823010
1538617/10/20075.59823011
1538717/10/20075.5982310
1538817/10/20075.5982311
1538917/10/20075.5982312
1539017/10/20075.5982313
1539117/10/20075.5982314
1539217/10/20075.5982315
1539317/10/20075.5982316
1539417/10/20075.5982317
1539517/10/20075.5982318
1539617/10/20075.5982319
1539717/10/20075.59823110
1539817/10/20075.59823111
1539917/10/20075.5982320
1540017/10/20075.5982321
1540117/10/20075.5982322
1540217/10/20075.5982323
1540317/10/20075.5982324
1540417/10/20075.5982325
1540517/10/20075.5982326
1540617/10/20075.5982327
1540717/10/20075.5982328
1540817/10/20075.5982329
1540917/10/20075.59823210
1541017/10/20075.59823211
1541117/10/20075.5982330
1541217/10/20075.5982331
1541317/10/20075.5982332
1541417/10/20075.5982333
1541517/10/20075.5982334
1541617/10/20075.5982335
1541717/10/20075.5982336
1541817/10/20075.5982337
1541917/10/20075.5982338
1542017/10/20075.5982339
1542117/10/20075.59823310
1542217/10/20075.59823311
1542317/10/20075.5982340
1542417/10/20075.5982341
1542517/10/20075.5982342
1542617/10/20075.5982343
1542717/10/20075.5982344
1542817/10/20075.5982345
1542917/10/20075.5982346
1543017/10/20075.5982347
1543117/10/20075.5982348
1543217/10/20075.5982349
1543317/10/20075.59823410
1543417/10/20075.59823411
1543517/10/20075.5982350
1543617/10/20075.5982351
1543717/10/20075.5982352
1543817/10/20075.5982353
1543917/10/20075.5982354
1544017/10/20075.5982355
1544117/10/20075.5982356
1544217/10/20075.5982357
1544317/10/20075.5982358
1544417/10/20075.5982359
1544517/10/20075.59823510
1544617/10/20075.59823511
1544717/10/20075.5982360
1544817/10/20075.5982361
1544917/10/20075.5982362
1545017/10/20075.5982363
1545117/10/20075.5982364
1545217/10/20075.5982365
1545317/10/20075.5982366
1545417/10/20075.5982367
1545517/10/20075.5982368
1545617/10/20075.5982369
1545717/10/20075.59823610
1545817/10/20075.59823611
1545917/10/20075.5982370
1546017/10/20075.5982371
1546117/10/20075.5982372
1546217/10/20075.5982373
1546317/10/20075.5982374
1546417/10/20075.5982375
1546517/10/20075.5982376
1546617/10/20075.5982377
1546717/10/20075.5982378
1546817/10/20075.5982379
1546917/10/20075.59823710
1547017/10/20075.59823711
1547117/10/20075.5982380
1547217/10/20075.5982381
1547317/10/20075.5982382
1547417/10/20075.5982383
1547517/10/20075.5982384
1547617/10/20075.5982385
1547717/10/20075.5982386
1547817/10/20075.5982387
1547917/10/20075.5982388
1548017/10/20075.5982389
1548117/10/20075.59823810
1548217/10/20075.59823811
1548317/10/20075.5982390
1548417/10/20075.5982391
1548517/10/20075.5982392
1548617/10/20075.5982393
1548717/10/20075.5982394
1548817/10/20075.5982395
1548917/10/20075.5982396
1549017/10/20075.5982397
1549117/10/20075.5982398
1549217/10/20075.5982399
1549317/10/20075.59823910
1549417/10/20075.59823911
1549517/10/20075.5982400
1549617/10/20075.5982401
1549717/10/20075.5982402
1549817/10/20075.5982403
1549917/10/20075.5982404
1550017/10/20075.5982405
1550117/10/20075.5982406
1550217/10/20075.5982407
1550317/10/20075.5982408
1550417/10/20075.5982409
1550517/10/20075.59824010
1550617/10/20075.59824011
1550717/10/20075.5982410
1550817/10/20075.5982411
1550917/10/20075.5982412
1551017/10/20075.5982413
1551117/10/20075.5982414
1551217/10/20075.5982415
1551317/10/20075.5982416
1551417/10/20075.5982417
1551517/10/20075.5982418
1551617/10/20075.5982419
1551717/10/20075.59824110
1551817/10/20075.59824111
1551917/10/20075.5982420
1552017/10/20075.5982421
1552117/10/20075.5982422
1552217/10/20075.5982423
1552317/10/20075.5982424
1552417/10/20075.5982425
1552517/10/20075.5982426
1552617/10/20075.5982427
1552717/10/20075.5982428
1552817/10/20075.5982429
1552917/10/20075.59824210
1553017/10/20075.59824211
1553117/10/20075.5982430
1553217/10/20075.5982431
1553317/10/20075.5982432
1553417/10/20075.5982433
1553517/10/20075.5982434
1553617/10/20075.5982435
1553717/10/20075.5982436
1553817/10/20075.5982437
1553917/10/20075.5982438
1554017/10/20075.5982439
1554117/10/20075.59824310
1554217/10/20075.59824311
1554317/10/20075.5982440
1554417/10/20075.5982441
1554517/10/20075.5982442
1554617/10/20075.5982443
1554717/10/20075.5982444
1554817/10/20075.5982445
1554917/10/20075.5982446
1555017/10/20075.5982447
1555117/10/20075.5982448
1555217/10/20075.5982449
1555317/10/20075.59824410
1555417/10/20075.59824411
1555517/10/20075.5982450
1555617/10/20075.5982451
1555717/10/20075.5982452
1555817/10/20075.5982453
1555917/10/20075.5982454
1556017/10/20075.5982455
1556117/10/20075.5982456
1556217/10/20075.5982457
1556317/10/20075.5982458
1556417/10/20075.5982459
1556517/10/20075.59824510
1556617/10/20075.59824511
1556717/10/20075.5982460
1556817/10/20075.5982461
1556917/10/20075.5982462
1557017/10/20075.5982463
1557117/10/20075.5982464
1557217/10/20075.5982465
1557317/10/20075.5982466
1557417/10/20075.5982467
1557517/10/20075.5982468
1557617/10/20075.5982469
1557717/10/20075.59824610
1557817/10/20075.59824611
1557917/10/20075.5982470
1558017/10/20075.5982471
1558117/10/20075.5982472
1558217/10/20075.5982473
1558317/10/20075.5982474
1558417/10/20075.5982475
1558517/10/20075.5982476
1558617/10/20075.5982477
1558717/10/20075.5982478
1558817/10/20075.5982479
1558917/10/20075.59824710
1559017/10/20075.59824711
1559117/10/20075.5982480
1559217/10/20075.5982481
1559317/10/20075.5982482
1559417/10/20075.5982483
1559517/10/20075.5982484
1559617/10/20075.5982485
1559717/10/20075.5982486
1559817/10/20075.5982487
1559917/10/20075.5982488
1560017/10/20075.5982489
1560117/10/20075.59824810
1560217/10/20075.59824811
1560317/10/20075.5982490
1560417/10/20075.5982491
1560517/10/20075.5982492
1560617/10/20075.5982493
1560717/10/20075.5982494
1560817/10/20075.5982495
1560917/10/20075.5982496
1561017/10/20075.5982497
1561117/10/20075.5982498
1561217/10/20075.5982499
1561317/10/20075.59824910
1561417/10/20075.59824911
1561517/10/20075.5982500
November 16, 2007 at 8:12 am
It is not quite clear what you are asking for. Can you give a written description of what you want to get back? Also include the result set that you would like to get back based on the sample data you've provided.
November 16, 2007 at 8:29 am
I get result with 5 columns which are as mentioned in my previous post.
You can see in the data that from yearvalue >=30 all the values become stagant.
I need to find yearvalue from where all the values become stagant.
Eg: In the above data I should be getting result of yearvalue=30
because from there onwards all the values becomes stagant.
Thanks for you help
Regards
November 16, 2007 at 8:41 am
OK, I think what you want is to find the values that correspond to the smallest YearValue for each Value. If this is correct, something like the following code should work. Keep in mind that I do not know your table name and I did not take the time to input all of your test data as there was so much. You will need to change the table name and test this yourself.
SELECT ID DateValue Value YearValue Monthvalue
FROM TableName t1
INNER JOIN (
SELECT Value, MIN(YearValue) as MinYear
FROM TableName
GROUP BY Value
) t2
ON t1.Value = t2.Value AND t1.YearValue = t2.MinYear
November 16, 2007 at 9:08 am
Thanks for your reply.
I know what you have done but I need further more complicated out out.
I am looking for YearValue from there onwards value become stagnant.
Regards
November 17, 2007 at 12:01 am
November 17, 2007 at 12:25 am
Hi,
Thanks for your reply.
It cant be all the time max value and it could be any value.
If I select max value then it will be wrong.
Regards
November 17, 2007 at 9:31 am
Ok, Nick... first, I gotta say that it's ok to post that much data, but if you're going to do that, the least you could do is make it easy on the folks that might try to help you... you need to make it so that your data builds a table without someone having to reformat 601 rows of data just so they can test...
... here's how to do that...
First, make a query similar to the following to put the data in the correct format for easy insertion with no additional formatting required...
SELECT 'SELECT '
+ QUOTENAME(ID,'''')+','
+ QUOTENAME(DateValue,'''')+','
+ QUOTENAME(Value,'''')+','
+ QUOTENAME(YearValue,'''')+','
+ QUOTENAME(MonthValue,'''')
+ ' UNION ALL'
FROM yourtable
That will return data that looks like this (number of rows abbreviated here for clarity)
SELECT '4','Oct 17 2007 12:00AM','5.1709','8','1' UNION ALL
SELECT '37','Oct 17 2007 12:00AM','5.5319','17','8' UNION ALL
SELECT '44','Oct 17 2007 12:00AM','5.5793','21','11' UNION ALL
SELECT '54','Oct 17 2007 12:00AM','5.2471','9','2' UNION ALL
SELECT '55','Oct 17 2007 12:00AM','5.1177','7','0' UNION ALL
SELECT '81','Oct 17 2007 12:00AM','5.5510','18','9' UNION ALL
SELECT '86','Oct 17 2007 12:00AM','5.5128','16','7' UNION ALL
SELECT '96','Oct 17 2007 12:00AM','5.5758','20','10' UNION ALL
Remove the last "UNION ALL" (highlighted in RED above) and add the correct INSERT statement the top of the code above...
SET DATEFORMAT DMY --Needed because of the date format you use
INSERT INTO #mytable
(ID ,DateValue ,Value ,YearValue,Monthvalue)
Create the correct temporary table creation code and add it to the top of the code...
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL
DROP TABLE #mytable
CREATE TABLE #mytable
(
ID INT PRIMARY KEY CLUSTERED,
DateValue DATETIME,
Value DECIMAL(9,4),
YearValue INT,
Monthvalue INT
)
When it's all combined, it'll look like the following (again, data rows abbreviated for clarity)... and, it'll entice more people to look at your problem because 1) They don't have to waste time formatting YOUR data to build a test table, 2) the table definition identifies the datatypes we need to know to solve your problem, 3) folks are more likely to give you a correct answer because they can actually test their answer on the data you've made easy to use.
IF OBJECT_ID('TempDB..#mytable','U') IS NOT NULL
DROP TABLE #mytable
CREATE TABLE #mytable
(
ID INT PRIMARY KEY CLUSTERED,
DateValue DATETIME,
Value DECIMAL(9,4),
YearValue INT,
Monthvalue INT
)
SET DATEFORMAT DMY
INSERT INTO #mytable
(ID ,DateValue ,Value ,YearValue,Monthvalue)
SELECT '4','Oct 17 2007 12:00AM','5.1709','8','1' UNION ALL
SELECT '37','Oct 17 2007 12:00AM','5.5319','17','8' UNION ALL
SELECT '44','Oct 17 2007 12:00AM','5.5793','21','11' UNION ALL
SELECT '54','Oct 17 2007 12:00AM','5.2471','9','2' UNION ALL
SELECT '55','Oct 17 2007 12:00AM','5.1177','7','0' UNION ALL
SELECT '81','Oct 17 2007 12:00AM','5.5510','18','9' UNION ALL
SELECT '86','Oct 17 2007 12:00AM','5.5128','16','7' UNION ALL
SELECT '96','Oct 17 2007 12:00AM','5.5758','20','10'
Ok... I'll get off the "forum etiquette soapbox"...
Assuming that the ID column is an autonumbering IDENTITY column and assuming that its numeric order also indicates the chronological relationship of rows (the lower the number, the earlier it was inserted), here's the answer that you're looking for...
SELECT v.*
FROM #MyTable v,
(--==== Derived table "fs" finds ID of the first row where stanation of VALUE occurs
SELECT MIN(ID) AS FirstIDOfStagnation
FROM #MyTable v,
(--==== Derived table "ls" finds last ID before stagnation of VALUE
SELECT MIN(ID) AS LastIDBeforeStagnation
FROM (--==== Derived table "x" finds the ID's of the last value and the value before that
SELECT TOP 2
Value, MAX(ID) AS ID
FROM #MyTable
GROUP BY Value
ORDER BY MAX(ID) DESC
)x
)ls
WHERE v.ID > ls.LastIDBeforeStagnation
)fs
WHERE v.ID = fs.FirstIDOfStagnation
Lemme know how that works out for you...
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply