SQL Query

Below is my query:
Select
Case
When SalesImportHistoryV2.RSID_TYPE = 'R'
Then SalesImportHistoryV2.RSID_EXTENDED
Else ''
End
from SalesImportHistoryV2


I get results: 15.56000
13.90000
2.99000
36.11000
19.55000
38.32000
40.96000
39.56000
9.76000
35.19000
39.15000
95.45000
7.14000
66.40000
14.08000
29.74000
4.40000
30.88000
30.88000
20.48000
30.88000
33.30000
20.26000
2.99000
3.28000
20.48000
42.32000
19.57000
35.52000
13.92000
23.68000
4.44000
11.12000
3.57000
11.79000
17.37000
7.04000
20.69000
1.51000
11.52000
14.08000
5.99000
8.00000
24.32000
35.52000
30.81000
21.00000
13.36000
7.52000
12.78000
16.94000
21.52000
63.65000
14.28000
35.60000
28.64000
37.63000
1.13000
14.08000
12.97000
14.08000
16.46000
26.24000
18.65000
33.93000
38.28000
35.20000
33.11000
11.16000
16.00000
32.00000
27.20000
64.64000
42.83000
99.60000
35.01000
23.16000
19.20000
41.38000
51.75000
36.11000
41.65000
21.60000
0.00000
22.30000
27.44000
22.77000
50.60000
37.29000
3.96000
58.88000
2.92000
25.24000
26.93000
0.00000
27.64000
36.86000
42.68000
26.86000
16.94000
25.06000
13.85000
13.44000
15.96000
13.40000
18.06000
2.65000
35.60000
0.00000
18.16000
11.46000
13.20000
15.07000
39.20000
49.92000
15.44000
35.36000
38.52000
40.96000
15.32000
33.90000
19.58000
63.30000
9.89000
36.70000
39.10000
34.50000
33.20000
103.50000
23.75000
30.88000
38.72000
12.73000
25.09000
13.20000
42.90000
26.80000
12.93000
11.64000
26.80000
36.85000
6.88000
25.60000
12.80000
2.72000
33.93000
25.28000
53.01000
28.61000
7.59000
41.40000
25.28000
17.77000
1.68000
1.70000
5.53000
15.52000
53.39000
7.22000
42.75000
32.36000
23.00000
26.20000
14.65000
21.52000
35.86000
18.96000
22.93000
7.90000
24.64000
25.28000
33.88000
1.09000
16.94000
34.44000
15.90000
37.62000
21.60000
25.84000
45.02000
16.80000
18.40000
54.34000
57.20000
20.54000
0.91000
16.51000
36.92000
17.77000
21.52000
11.36000
17.47000
6.80000
26.32000
20.96000
33.88000
10.59000
12.64000
2.44000
12.07000
20.93000
13.40000
12.45000
62.25000
71.20000
35.60000
8.30000
7.14000
20.75000
4.72000
33.36000
11.50000
74.94000
34.80000
6.50000
15.44000
52.90000
36.80000
29.90000
7.44000
20.48000
34.80000
29.63000
21.34000
10.71000
22.72000
16.51000
25.28000
5.44000
34.76000
11.36000
18.96000
5.32000
4.25000
7.56000
17.38000
10.44000
11.60000
25.46000
26.70000
83.00000
6.36000
70.89000
30.59000
38.00000
16.60000
15.44000
26.93000
3.80000
38.72000
37.63000
27.60000
28.74000
35.46000
21.07000
27.56000
30.31000
40.02000
20.80000
19.30000
4.29000
37.31000
27.84000
4.29000
3.22000
2.44000
3.01000
18.67000
13.35000
45.65000
40.05000
4.75000
23.16000
31.52000
5.90000
28.74000
9.95000
23.68000
4.12000
40.80000
14.00000
28.00000
14.74000
5.25000
29.48000
29.48000
0.00000
37.20000
57.00000
4.65000
8.30000
12.45000
77.60000
69.75000
10.71000
27.90000
101.84000
41.38000
23.16000
6.60000
36.00000
29.40000
12.51000
29.40000
7.59000
41.40000
48.00000
35.44000
8.58000
6.90000
20.58000
3.84000
13.35000
0.00000
9.34000
70.01000
41.71000
9.50000
6.47000
6.46000
23.16000
40.00000
50.60000
30.31000
2.96000
20.88000
3.50000
25.60000
22.57000
23.76000
57.29000
22.28000
89.06000
71.20000
22.25000
24.66000
28.50000
19.76000
0.00000
16.60000
10.37000
10.71000
38.00000
36.15000
49.80000
60.30000
21.12000
20.69000
30.56000
21.67000
23.94000
9.65000
27.60000
40.00000
37.31000
17.49000
5.60000
13.99000
37.31000
20.88000
17.04000
22.00000
14.59000
52.16000
26.08000
27.52000
23.29000
68.47000
32.30000
35.69000
0.00000
89.06000
67.81000
6.36000
101.84000
3.88000
62.40000
61.76000
3.88000
18.87000
11.79000
5.93000
9.20000
3.50000
26.40000
12.86000
22.15000
63.36000
61.20000
28.55000
64.64000
6.36000
38.00000
60.67000
27.24000
39.20000
41.11000
5.80000
18.27000
75.20000
30.82000
19.89000
246.75000
9.89000
30.48000
15.52000
7.59000
15.36000
12.80000
35.36000
25.60000
18.40000
29.16000
30.72000
14.00000
0.00000
6.88000
22.55000
5.86000
41.80000
18.09000
47.06000
1.81000
31.84000
67.20000
32.00000
7.24000
24.64000
21.52000
40.80000
17.04000
1.90000
21.52000
13.44000
13.44000
37.12000
31.68000
15.91000
28.55000
102.30000
70.01000
4.72000
14.08000
30.56000
8.58000
17.15000
34.50000
25.73000
19.78000
60.90000
10.24000
52.90000
58.19000
6.53000
40.64000
13.87000
57.00000
189.25000
45.65000
13.90000
40.05000
15.52000
21.98000
8.80000
23.16000
4.34000
30.40000
5.28000
14.15000
4.54000
27.60000
19.20000
10.49000
24.00000
3.50000
41.76000
48.16000
0.00000
37.62000
33.66000
33.25000
8.47000
2.37000
33.88000
2.85000
4.62000
15.30000
3.38000
27.36000
3.54000
31.52000
15.44000
44.62000
19.40000
50.40000
22.51000
32.00000
15.52000
12.64000
25.52000
18.48000
43.04000
5.37000
14.67000
54.89000
3.18000
21.30000
18.48000
14.31000
7.45000
20.52000
31.20000
32.64000
39.37000
32.30000
21.00000
13.80000
14.27000
12.09000
12.07000
18.00000
5.29000
25.28000
25.28000
36.92000
21.30000
29.62000
18.96000
37.66000
8.75000
9.55000
33.20000
22.40000
5.73000
42.02000
3.84000
6.60000
8.44000
58.50000
39.20000
22.05000
3.31000
40.50000
45.94000
30.96000
41.60000
6.16000
49.31000
20.58000
131.56000
59.52000
27.44000
22.77000
41.40000
3.47000
20.32000
15.48000
23.28000
2.81000
12.33000
12.09000
11.36000
6.16000
24.64000
16.94000
50.56000
15.62000
2.12000
11.36000
18.46000
25.28000
24.87000
29.62000
1.90000
12.70000
21.52000
4.35000
19.32000
26.88000
21.00000
22.24000
66.83000
16.46000
30.40000
31.15000
37.20000
23.85000
9.55000
20.69000
45.84000
25.31000
36.11000
0.00000
37.76000
8.62000
69.63000
12.65000
65.78000
40.96000
34.80000
18.40000
30.48000
37.73000
33.90000
36.19000
19.78000
81.92000
34.82000
6.86000
38.00000
13.95000
89.22000
43.70000
1.76000
3.82000
16.40000
20.69000
28.47000
23.66000
36.97000
17.60000
18.65000
26.62000
18.65000
20.88000
4.51000
2.78000
10.01000
50.92000
74.70000
8.30000
7.14000
78.52000
28.50000
29.92000
6.40000
36.10000
28.45000
26.25000
1.87000
52.50000
19.14000
6.63000
7.00000
29.75000
46.00000
75.65000
60.56000
4.15000
19.30000
18.05000
46.32000
12.41000
6.47000
49.20000
21.12000
28.12000
10.00000
12.80000
20.88000
11.74000
8.16000
26.81000
31.68000
15.84000
26.93000
12.73000
21.98000
28.45000
27.00000
5.15000
73.60000
37.58000
23.00000
40.48000
50.60000
34.40000
25.60000
19.82000
35.64000
0.00000
24.00000
18.00000
12.97000
30.97000
62.08000
22.51000
31.04000
22.51000
13.80000
40.96000
12.65000
19.17000
9.77000
4.26000
23.12000
23.12000
40.80000
15.97000
11.84000
11.60000
36.12000
29.48000
9.02000
74.40000
53.40000
66.75000
69.75000
49.80000
50.60000
46.44000
24.36000
35.36000
27.44000
7.59000
25.60000
25.60000
45.29000
29.32000
33.63000
59.80000
8.34000
3.49000
50.92000
53.40000
67.69000
25.02000
17.55000
36.67000
30.88000
21.94000
12.82000
12.97000
6.64000
0.00000
27.60000
51.20000
30.24000
3.50000
17.69000
6.63000
10.61000
8.58000
40.96000
37.40000
11.36000
15.12000
29.92000
0.00000
23.64000
30.88000
1.51000
50.40000
32.00000
26.73000
20.11000
16.94000
25.28000
4.89000
21.52000
18.48000
81.92000
20.11000
21.52000
13.44000
27.04000
34.27000
22.35000
22.61000
21.42000
11.64000
6.70000
13.00000
28.16000
0.00000
0.00000
8.53000
25.28000
16.94000
4.62000
42.50000
16.94000
11.36000
12.78000
12.70000
25.28000
7.15000
33.25000
78.85000
91.85000
6.40000
26.26000
52.77000
40.50000
10.57000
19.70000
11.50000
40.64000
18.40000
34.56000
23.00000
29.28000
27.44000
27.60000
36.80000
37.95000
27.87000
24.57000
44.62000
33.60000
22.51000
23.28000
36.80000
27.44000
18.40000
21.76000
21.19000
45.44000
3.08000
16.08000
22.72000
29.31000
8.52000
13.44000
13.44000
3.16000
13.44000
3.16000
21.45000
12.45000
33.25000
86.77000
54.10000
56.02000
37.20000
16.68000
21.41000
13.20000
3.84000
49.25000
41.01000
6.05000
30.88000
42.24000
2.30000
17.40000
7.48000
4.66000
18.65000
28.71000
21.78000
6.63000
4.69000
7.00000
47.52000
50.05000
70.55000
45.65000
85.66000
22.92000
28.16000
3.94000
31.82000
11.64000
12.97000
43.70000
36.21000
44.40000
27.84000
2.96000
41.76000
22.15000
18.65000
25.60000
19.25000
12.90000
63.28000
74.40000
102.30000
4.65000
80.75000
62.25000
21.75000
15.52000
25.32000
14.77000
14.17000
29.55000
31.65000
6.16000
55.66000
8.71000
33.00000
29.16000
25.60000
3.43000
15.41000
57.00000
45.65000
60.47000
15.91000
55.76000
25.84000
45.60000
30.88000
18.65000
12.16000
26.40000
35.20000
5.29000
42.00000
42.00000
42.00000
31.82000
44.49000
49.80000
91.30000
26.25000
28.16000
31.68000
12.93000
23.03000
10.61000
8.47000
23.16000
4.72000
6.64000
9.65000
2.61000
13.99000
18.00000
40.44000
5.06000
16.94000
115.70000
57.00000
99.60000
7.74000
74.40000
20.75000
14.47000
1.45000
0.00000
38.72000
3.03000
20.69000
23.16000
30.40000
29.92000
12.93000
25.94000
23.28000
12.93000
5.36000
43.50000
20.98000
5.22000
19.30000
10.49000
13.27000
5.86000
31.50000
20.00000
24.90000
12.92000
32.30000
0.00000
7.87000
39.20000
7.91000
36.11000
16.68000
5.86000
15.44000
8.58000
18.40000
11.87000
27.90000
57.36000
50.60000
95.70000
31.65000
7.91000
27.74000
8.70000
40.48000
17.68000
23.76000
23.88000
6.81000
22.55000
0.00000
31.04000
34.92000
33.60000
37.14000
25.28000
11.36000
17.54000
21.52000
24.64000
18.00000
31.38000
11.36000
10.59000
26.07000
21.52000
10.59000
20.54000
34.76000
0.00000
6.11000
6.73000
21.10000
0.82000
4.80000
37.35000
53.44000
50.05000
20.69000
3.86000
2.99000
6.75000
18.00000
7.35000
31.85000
34.56000
7.62000
29.16000
43.70000
34.80000
47.85000
27.44000
40.92000
7.80000
3.84000
88.88000
53.40000
4.75000
64.64000
9.85000
21.98000
3.82000
21.71000
5.91000
54.21000
24.57000
40.48000
5.90000
15.84000
48.53000
30.88000
5.83000
19.57000
10.72000
19.82000
31.84000
38.50000
57.29000
1.50000
50.60000
21.49000
24.64000
13.41000
29.33000
33.60000
52.77000
23.40000
19.40000
39.10000
15.44000
33.00000
8.58000
29.91000
18.00000
18.00000
6.32000
17.00000
14.82000
17.15000
14.20000
20.28000
16.25000
8.80000
1.56000
20.50000
2.91000
19.40000
25.33000
5.01000
33.63000
36.80000
36.98000
59.80000
1.63000
18.00000
12.70000
25.28000
16.94000
13.60000
36.75000
6.15000
64.64000
63.28000
28.64000
3.82000
27.56000
0.00000
27.00000
32.40000
41.70000
41.16000
7.70000
34.80000
11.50000
25.73000
6.53000
41.16000
28.80000
11.87000
46.08000
12.93000
51.74000
32.00000
32.00000
31.04000
6.48000
29.59000
31.24000
20.96000
20.40000
14.48000
2.69000
36.92000
22.93000
6.32000
14.22000
14.28000
13.44000
9.24000
7.56000
41.71000
70.55000
45.65000
126.59000
12.93000
19.30000
56.32000
0.00000
11.79000
0.00000
30.56000
7.72000
4.87000
27.20000
18.65000
18.65000
11.66000
16.32000
17.49000
27.84000
13.27000
23.88000
99.60000
74.40000
64.24000
75.70000
62.25000
6.36000
31.82000
31.52000
20.69000
18.87000
28.16000
11.79000
0.00000
16.40000
48.64000
46.08000
29.90000
30.48000
32.64000
49.64000
4.60000
27.60000
15.68000
10.12000
7.68000
40.64000
21.76000
40.96000
44.16000
40.96000
51.43000
7.68000
8.58000
6.36000
54.70000
44.55000
76.00000
74.40000
28.64000
42.75000
14.52000
30.56000
2.85000
12.73000
23.16000
1.93000
28.50000
42.02000
28.50000
14.22000
19.20000
5.83000
26.10000
0.00000
10.49000
6.52000
13.40000
6.63000
8.75000
6.36000
120.90000
7.14000
56.74000
8.30000
99.60000
0.00000
31.82000
41.37000
19.40000
28.95000
24.61000
30.88000
26.56000
19.92000
21.12000
15.28000
7.92000
40.00000
22.18000
11.84000
10.72000
27.84000
11.66000
55.68000
26.40000
4.88000
32.00000
4.00000
26.96000
18.76000
22.55000
1.98000
16.36000
10.86000
16.94000
2.12000
33.25000
46.50000
15.91000
62.25000
81.94000
33.29000
30.88000
24.57000
3.52000
30.56000
49.66000
11.64000
18.40000
19.20000
22.02000
18.57000
33.81000
18.65000
2.14000
10.49000
6.09000
17.40000
9.65000
18.65000
0.00000
30.01000
3.48000
14.00000
36.75000
64.64000
6.36000
51.95000
5.91000
24.61000
5.79000
16.41000
39.20000
35.84000
34.12000
66.04000
3.43000
73.60000
59.80000
40.96000
8.58000
31.32000
6.63000
15.84000
10.50000
12.06000
42.02000
6.47000
15.28000
3.42000
13.00000
14.07000
33.60000
40.74000
25.28000
9.51000
0.00000
5.29000
17.04000
25.28000
22.16000
23.70000
25.28000
17.04000
20.14000
15.22000
10.59000
0.00000
13.44000
31.68000
0.00000
15.91000
16.60000
26.28000
34.79000
20.21000
7.08000
46.08000
5.20000
40.96000
2.54000
35.51000
20.48000
17.42000
15.41000
40.64000
15.44000
1.86000
66.40000
104.50000
14.25000
67.80000
42.83000
10.56000
15.76000
2.59000
2.36000
5.07000
49.25000
43.70000
29.58000
10.72000
6.96000
11.66000
5.83000
15.66000
22.18000
11.66000
19.82000
11.72000
34.21000
32.00000
13.40000
31.68000
8.58000
12.80000
18.40000
0.00000
15.67000
9.85000
33.60000
13.00000
26.77000
7.87000
20.80000
18.29000
22.51000
45.77000
35.60000
6.32000
23.29000
16.59000
9.53000
28.44000
18.96000
15.01000
24.14000
14.79000
24.64000
17.04000
16.94000
7.65000
3.18000
21.97000
27.04000
25.33000
18.90000
15.52000
12.66000
45.02000
31.04000
14.67000
13.80000
22.32000
0.00000
18.96000
9.51000
23.70000
41.89000
5.29000
10.59000
24.64000
9.53000
31.68000
7.42000
2.64000
16.94000
39.20000
8.21000
0.00000
21.37000
52.10000
33.36000
36.75000
37.76000
40.96000
41.16000
0.00000
19.94000
15.41000
22.30000
40.64000
27.60000
13.72000
15.44000
0.00000
0.00000
16.00000
3.88000
50.60000
25.60000
7.61000
17.04000
22.72000
16.94000
20.11000
11.71000
57.00000
58.56000
82.74000
29.55000
30.88000
5.79000
11.46000
17.62000
28.98000
28.64000
3.01000
45.00000
0.00000
37.76000
28.16000
80.96000
52.90000
1.98000
15.24000
37.95000
1.54000
20.48000
56.32000
12.95000
2.30000
17.71000
40.59000
37.95000
25.02000
57.85000
8.90000
76.00000
49.80000
0.00000
8.90000
93.45000
7.04000
22.80000
15.44000
15.52000
10.34000
3.96000
31.35000
4.54000
14.08000
32.80000
1.93000
21.12000
42.46000
41.25000
9.20000
25.73000
27.84000
21.00000
16.46000
9.33000
35.20000
31.20000
20.88000
20.37000
17.49000
8.87000
63.68000
23.76000
14.74000
27.20000
22.00000
19.90000
43.31000
11.93000
15.28000
30.88000
5.98000
20.48000
2.56000
43.15000
20.05000
26.52000
20.48000
26.25000
24.19000
11.74000
16.00000
26.53000
4.00000
18.65000
42.45000
10.61000
31.68000
27.20000
26.96000
0.00000
21.23000
7.62000
23.04000
9.51000
30.59000
91.30000
8.34000
63.95000
19.40000
24.57000
3.96000
61.76000
0.00000
16.25000
31.52000
0.00000
22.40000
16.08000
21.44000
20.00000
8.75000
0.00000
9.35000
38.00000
42.46000
0.00000
22.50000
40.09000
7.70000
12.65000
54.89000
30.72000
13.06000
44.07000
29.28000
21.57000
40.96000
8.00000
18.00000
24.08000
15.92000
5.09000
23.00000
4.62000
27.60000
30.60000
21.52000
29.61000
20.54000
3.19000
20.11000
20.11000
44.20000
19.31000
11.36000
12.64000
33.88000
20.02000
18.96000
0.00000
11.44000
8.00000
66.40000
35.69000
58.56000
52.25000
4.45000
5.79000
25.09000
17.60000
7.24000
20.21000
55.20000
31.65000
0.00000
54.89000
4.60000
43.52000
3.96000
3.88000
11.88000
9.60000
7.50000
4.29000
27.84000
9.33000
25.50000
14.74000
10.10000
4.00000
25.73000
8.06000
3.95000
18.08000
21.88000
21.52000
11.05000
18.70000
13.44000
0.00000
0.45000
18.90000
15.92000
0.00000
22.77000
30.44000
4.74000
0.00000
25.28000
21.30000
27.34000
21.52000
6.54000
15.62000
13.05000
3.48000
23.84000
10.61000
31.68000
17.91000
26.73000
33.60000
40.96000
66.56000
6.20000
10.66000
16.81000
22.83000
12.70000
18.08000
6.52000
10.20000
10.08000
10.10000
31.68000
25.33000
27.20000
18.06000
42.75000
4.72000
24.57000
26.40000
3.94000
19.70000
25.84000
48.24000
4.74000
6.75000
39.20000
4.06000
39.40000
33.16000
2.25000
30.72000
25.60000
9.20000
13.87000
21.76000
29.28000
28.16000
23.32000
0.00000
3.08000
23.00000
10.40000
6.00000
40.96000
41.54000
20.58000
6.90000
66.70000
35.86000
13.60000
25.41000
14.67000
25.41000
27.76000
13.60000
1.90000
5.68000
25.50000
4.74000
0.00000
2.55000
20.16000
10.92000
26.88000
13.44000
10.08000
9.24000
15.96000
64.64000
25.46000
57.10000
76.38000
17.60000
23.16000
42.46000
5.28000
17.37000
37.20000
56.02000
49.80000
24.90000
85.66000
10.34000
30.88000
2.59000
34.67000
4.92000
27.00000
22.33000
22.61000
1.83000
39.10000
36.80000
17.15000
4.30000
37.73000
0.00000
38.10000
39.15000
22.77000
36.80000
27.60000
7.91000
18.40000
41.60000
8.48000
45.29000
10.71000
70.55000
22.24000
71.59000
50.92000
70.55000
30.59000
2.59000
13.20000
29.74000
28.16000
15.20000
26.24000
3.52000
10.34000
31.68000
19.09000
3.48000
27.98000
9.33000
20.88000
32.72000
25.50000
37.20000
14.25000
15.31000
10.34000
36.85000
42.24000
30.56000
30.15000
22.62000
18.22000
26.81000
6.80000
25.65000
38.40000
20.98000
27.20000
9.38000
11.09000
11.72000
20.54000
22.23000
75.65000
89.00000
37.50000
5.90000
27.12000
28.16000
3.82000
20.69000
20.48000
3.94000
33.44000
36.33000
14.15000
12.50000
9.74000
24.48000
17.15000
13.99000
19.25000
26.25000
0.00000
30.69000
26.96000
3.49000
33.39000
34.74000
10.34000
13.72000
33.36000
18.97000
17.25000
11.73000
5.12000
41.54000
33.28000
5.06000
43.01000
23.74000
27.23000
46.08000
40.96000
52.90000
32.77000
69.63000
33.90000
7.10000
3.50000
0.00000
30.69000
0.00000
14.59000
2.68000
31.84000
7.52000
31.68000
21.23000
19.40000
22.51000
31.04000
50.40000
29.55000
41.54000
4.30000
4.39000
17.00000
22.72000
2.85000
16.51000
24.21000
25.28000
2.61000
17.64000
28.14000
31.50000
26.96000
4.51000
21.23000
1.40000
14.28000
46.32000
29.48000
29.55000
20.05000
3.03000
30.88000
7.08000
71.05000
18.00000
0.00000
41.92000
30.72000
10.04000
34.80000
66.70000
13.87000
36.80000
36.80000
10.12000
13.80000
55.20000
40.64000
18.40000
0.00000
5.93000
27.80000
37.20000
28.01000
35.69000
42.83000
37.35000
28.16000
3.86000
40.48000
23.28000
18.22000
12.82000
10.80000
11.79000
17.69000
0.00000
37.62000
40.25000
26.97000
31.68000
17.00000
1.49000
20.32000
27.52000
7.88000
30.95000
4.96000
19.94000
43.12000
80.96000
55.20000
41.18000
19.05000
12.78000
9.29000
15.80000
14.16000
11.64000
21.52000
12.32000
54.08000
23.84000
34.27000
35.76000
16.91000
41.60000
2.85000
8.85000
17.04000
35.70000
5.10000
7.24000
37.92000
12.70000
16.51000
2.52000
27.86000
26.96000
3.52000
24.22000
25.09000
7.91000
18.00000
0.00000
53.76000
63.30000
16.95000
36.80000
39.10000
15.52000
10.40000
31.65000
21.76000
17.55000
20.02000
3.90000
0.00000
44.62000
44.62000
19.40000
11.26000
31.04000
3.98000
23.74000
4.96000
31.65000
0.00000
37.58000
11.50000
31.79000
24.21000
23.10000
2.12000
3.18000
26.86000
29.26000
30.70000
11.44000
18.17000
10.08000
18.17000
20.16000
12.64000
13.44000
13.44000
19.75000
22.25000
47.27000
28.16000
12.93000
28.30000
3.88000
28.76000
47.64000
25.94000
39.20000
19.78000
58.19000
34.54000
9.20000
41.40000
20.32000
39.45000
13.80000
65.00000
40.64000
35.60000
49.92000
43.70000
32.77000
6.53000
2.44000
10.59000
32.00000
34.81000
26.25000
19.20000
14.07000
27.04000
46.20000
15.75000
15.41000
52.20000
10.58000
12.70000
3.95000
38.62000
21.52000
3.95000
18.32000
5.68000
28.40000
8.07000
24.64000
26.28000
4.03000
8.50000
10.27000
16.15000
6.32000
3.16000
14.90000
23.84000
25.33000
18.00000
27.04000
31.04000
21.44000
3.37000
1.35000
30.07000
18.87000
8.81000
17.10000
20.23000
16.51000
24.64000
2.44000
38.62000
22.72000
20.94000
11.84000
13.44000
2.86000
41.50000
38.27000
9.50000
12.32000
15.84000
39.36000
26.44000
14.77000
33.36000
22.28000
24.66000
33.63000
27.44000
5.20000
31.65000
51.43000
34.80000
13.05000
32.59000
36.34000
28.64000
4.15000
14.28000
21.79000
18.87000
47.28000
20.69000
12.93000
49.25000
29.04000
5.73000
19.36000
39.36000
12.16000
27.84000
33.93000
12.00000
38.28000
21.44000
15.92000
44.00000
7.92000
13.12000
25.98000
22.51000
18.35000
3.98000
15.48000
27.44000
5.12000
40.64000
15.24000
12.64000
21.52000
22.72000
17.77000
4.03000
17.77000
24.46000
11.36000
12.75000
20.88000
1.70000
11.44000
0.79000
0.79000
12.60000
8.70000
0.85000
11.44000
64.64000
57.10000
6.64000
7.92000
53.90000
24.86000
10.66000
54.56000
17.15000
23.74000
4.60000
5.75000
7.62000
35.60000
27.60000
8.05000
12.80000
50.83000
21.76000
20.70000
27.12000
17.28000
36.52000
40.16000
36.57000
174.02000
38.19000
96.96000
47.70000
48.95000
42.83000
74.40000
10.71000
10.71000
109.25000
29.05000
76.00000
60.56000
38.70000
39.82000
22.51000
15.52000
12.06000
25.22000
12.13000
23.12000
37.38000
4.62000
36.96000
3.34000
6.56000
6.45000
9.28000
0.33000
62.25000
92.62000
42.33000
19.72000
5.43000
29.63000
18.68000
13.33000
28.96000
20.00000
11.76000
27.04000
13.44000
3.95000
4.20000
3.36000
91.30000
12.45000
64.24000
20.48000
1.50000
3.54000
14.22000
27.34000
4.50000
50.69000
6.12000
32.77000
18.40000
5.20000
36.80000
33.28000
39.79000
55.20000
50.60000
8.70000
6.90000
37.58000
25.60000
31.24000
27.71000
13.44000
23.84000
8.45000
41.50000
74.40000
74.70000
20.69000
7.64000
15.28000
3.52000
6.64000
39.37000
34.00000
8.88000
18.65000
26.81000
12.82000
22.80000
13.44000
3.16000
11.44000
12.64000
20.88000
1.58000
4.25000
46.50000
30.24000
21.01000
14.48000
19.00000
28.18000
2.02000
8.40000
1.23000
10.66000
1.20000
0.00000
4.80000
6.15000
17.76000
16.67000
11.66000
23.78000
12.00000
48.00000
27.20000
2.15000
9.84000
34.14000
34.25000
31.36000
28.89000
4.07000
6.79000
2.01000
10.16000
10.65000
15.52000
49.20000
36.19000
46.32000
30.40000
40.48000
14.15000
21.12000
18.40000
17.15000
26.40000
8.58000
19.82000
5.83000
18.65000
19.80000
23.76000
13.27000
16.60000
76.00000
148.80000
36.19000
24.12000
25.84000
30.40000
41.38000
2.64000
41.40000
42.50000
17.40000
20.88000
11.79000
1.17000
6.80000
34.84000
5.05000
11.72000
11.88000
63.36000
35.69000
60.67000
98.62000
91.30000
9.65000
30.68000
29.90000
41.40000
27.60000
77.40000
9.89000
61.44000
32.32000
18.48000
6.63000
23.76000
32.00000
13.27000
47.06000
6.77000
25.20000
31.84000
31.04000
16.88000
10.40000
15.60000
4.97000
52.16000
7.90000
1.90000
37.92000
14.67000
39.10000
23.43000
25.28000
25.28000
6.72000
36.92000
11.44000
4.47000
5.07000
48.96000
37.43000
16.00000
36.58000
29.10000
11.64000
1.30000
63.30000
11.50000
8.62000
15.52000
33.88000
4.26000
26.56000
27.72000
8.56000
3.95000
27.20000
12.64000
1.68000
9.48000
7.65000
3.40000
13.60000
20.54000
21.00000
8.40000
19.14000
3.18000
35.27000
30.85000
16.75000
59.00000
27.00000
27.44000
12.33000
81.92000
32.59000
24.66000
24.66000
41.02000
40.96000
65.00000
33.88000
7.61000
19.76000
44.49000
64.64000
24.57000
46.32000
22.92000
12.93000
45.31000
21.12000
14.53000
4.00000
32.62000
8.00000
9.33000
9.65000
55.68000
2.14000
14.00000
6.02000
10.00000
50.55000
30.00000
6.56000
7.79000
30.85000
47.06000
4.22000
18.40000
55.88000
20.70000
27.20000
33.88000
21.52000
5.29000
21.49000
36.92000
3.18000
17.04000
7.40000
8.69000
16.53000
16.15000
23.52000
11.44000
17.84000
9.55000
55.33000
55.80000
42.46000
42.24000
39.57000
58.50000
60.72000
78.30000
13.87000
8.58000
4.35000
3.95000
14.77000
5.32000
10.59000
38.74000
103.75000
33.37000
21.37000
95.45000
99.60000
70.55000
35.69000
33.20000
24.90000
7.14000
24.98000
42.45000
53.91000
69.14000
39.00000
31.84000
32.00000
33.94000
10.91000
57.92000
3.64000
10.01000
3.64000
10.91000
14.93000
21.72000
6.56000
3.90000
9.84000
4.92000
0.99000
4.30000
4.15000
22.71000
15.71000
9.20000
27.15000
31.20000
2.71000
9.70000
14.45000
15.76000
33.15000
3.94000
54.08000
0.00000
20.10000
3.95000
13.44000
53.95000
50.92000
63.65000
3.82000
42.24000
39.20000
4.17000
27.00000
23.94000
45.56000
30.72000
29.16000
36.80000
55.20000
5.15000
50.60000
8.84000
9.77000
43.81000
5.11000
44.07000
26.00000
48.00000
20.48000
24.87000
7.90000
0.00000
47.74000
53.95000
42.02000
15.52000
43.34000
25.84000
5.28000
2.89000
56.32000
24.57000
24.57000
34.38000
24.47000
32.62000
18.96000
20.16000
26.88000
2.37000
0.90000
11.26000
34.50000
19.72000
32.23000
20.16000
46.62000
33.64000
42.90000
7.80000
19.91000
23.76000
66.75000
132.80000
49.80000
24.57000
15.76000
7.60000
16.58000
16.10000
8.62000
34.80000
57.50000
17.71000
7.62000
18.40000
39.17000
29.25000
8.58000
9.20000
11.35000
18.34000
15.97000
17.38000
26.96000
30.88000
23.10000
30.95000
1.94000
26.73000
15.52000
48.00000
30.42000
27.74000
76.38000
16.94000
10.32000
20.11000
1.22000
7.10000
1.22000
16.94000
27.84000
11.44000
37.92000
3.38000
14.90000
16.39000
7.20000
20.28000
7.24000
49.25000
6.73000
5.82000
23.40000
49.45000
23.74000
18.00000
20.96000
11.36000
22.72000
37.40000
0.79000
2.52000
18.48000
14.28000
15.96000
13.60000
18.96000
12.64000
60.47000
52.83000
9.30000
83.70000
50.92000
38.90000
3.88000
7.60000
34.83000
9.80000
12.25000
31.57000
7.62000
25.30000
27.44000
23.94000
61.44000
10.88000
59.80000
10.35000
22.72000
8.74000
16.94000
49.80000
71.20000
22.25000
5.28000
21.23000
9.84000
2.64000
22.15000
9.33000
25.60000
21.60000
28.00000
30.29000
12.90000
19.80000
24.00000
7.59000
23.28000
28.60000
54.24000
27.52000
13.16000
20.11000
3.18000
1.22000
28.90000
20.23000
33.18000
14.22000
8.50000
8.69000
15.96000
19.00000
17.84000
47.27000
37.20000
3.49000
39.26000
24.57000
20.05000
2.64000
72.00000
13.13000
24.66000
4.90000
5.08000
16.10000
0.00000
40.48000
24.32000
30.72000
46.80000
34.80000
38.10000
40.64000
48.07000
27.44000
40.64000
18.40000
41.40000
23.00000
36.45000
3.66000
40.35000
25.56000
11.36000
8.47000
27.04000
25.65000
27.04000
32.06000
13.35000
32.32000
104.50000
35.69000
57.00000
64.64000
0.00000
48.00000
29.70000
25.20000
26.73000
7.03000
19.40000
18.26000
45.90000
-45.90000
47.50000
60.56000
97.90000
36.96000
19.60000
5.85000
11.76000
31.36000
23.40000
28.96000
31.36000
31.36000
26.64000
19.70000
24.43000
31.84000
6.23000
21.01000
13.44000
33.20000
2.59000
29.53000
28.69000
7.35000
11.80000
39.40000
39.20000
36.00000
16.95000
11.87000
61.44000
9.89000
39.78000
30.72000
20.24000
16.10000
8.58000
23.74000
65.25000
1.42000
0.00000
23.84000
19.08000
45.65000
29.05000
67.81000
12.45000
0.00000
21.41000
7.88000
35.46000
20.69000
30.56000
26.80000
24.70000
20.69000
13.79000
30.88000
23.16000
27.84000
5.83000
1.24000
6.72000
13.44000
8.69000
7.65000
5.10000
9.48000
9.24000
27.20000
12.38000
22.08000
24.95000
52.35000
6.56000
6.56000
7.79000
9.54000
1.64000
12.87000
11.47000
9.60000
22.00000
7.00000
56.00000
0.33000
6.16000
37.05000
1.81000
21.01000
3.98000
22.61000
63.25000
19.58000
18.34000
2.05000
18.70000
4.20000
45.77000
5.25000
42.67000
34.67000
29.99000
41.65000
17.91000
21.56000
40.96000
19.17000
6.56000
9.43000
0.60000
44.55000
63.00000
33.88000
20.11000
16.94000
14.27000
13.44000
8.40000
1.70000
34.44000
39.26000
28.64000
41.38000
38.60000
19.71000
4.34000
11.64000
21.12000
29.80000
33.29000
32.19000
30.88000
36.96000
19.30000
3.86000
0.00000
0.00000
2.50000
15.66000
27.84000
1.65000
79.03000
31.82000
14.08000
9.50000
6.47000
41.38000
11.46000
33.19000
36.19000
7.72000
33.81000
37.31000
5.83000
40.02000
23.68000
20.98000
20.11000
49.50000
14.00000
0.00000
31.68000
31.12000
50.05000
24.90000
60.56000
76.00000
76.00000
7.12000
76.00000
0.00000
51.45000
27.00000
43.70000
40.96000
5.93000
48.00000
10.24000
27.44000
31.00000
37.95000
58.19000
27.60000
15.80000
11.39000
28.00000
46.00000
32.00000
32.16000
52.00000
33.60000
32.00000
13.00000
5.49000
38.01000
24.66000
36.34000
9.53000
10.59000
2.12000
15.80000
20.14000
12.64000
34.27000
0.00000
19.37000
25.44000
18.59000
33.60000
39.37000
11.94000
36.22000
33.60000
54.40000
32.77000
18.40000
53.17000
21.76000
41.60000
-41.60000
17.04000
15.88000
6.32000
26.07000
15.80000
8.40000
21.84000
13.60000
20.40000
13.44000
0.84000
20.01000
13.44000
12.64000
0.00000
41.50000
24.98000
31.82000
12.73000
16.58000
0.00000
30.72000
41.34000
8.58000
33.57000
8.58000
9.77000
17.15000
30.72000
17.20000
28.44000
132.80000
4.75000
28.64000
41.50000
37.20000
30.40000
6.47000
20.69000
12.93000
7.24000
33.10000
30.88000
12.93000
45.31000
34.74000
29.04000
10.49000
6.09000
26.87000
15.16000
1.98000
11.89000
5.28000
30.88000
27.86000
21.00000
31.84000
-31.84000
42.00000
31.50000
9.53000
10.59000
27.20000
21.67000
5.29000
37.92000
27.25000
12.70000
14.22000
15.80000
10.59000
4.74000
2.12000
41.89000
3.19000
25.28000
1.22000
3.18000
0.00000
27.25000
3.36000
8.69000
15.12000
11.44000
13.44000
8.40000
26.88000
13.44000
12.64000
0.84000
15.96000
2.52000
4.20000
76.00000
44.49000
50.92000
13.46000
12.93000
19.60000
7.62000
8.58000
23.37000
9.30000
9.89000
40.96000
34.81000
32.64000
43.70000
9.60000
40.96000
34.80000
5.29000
3.16000
18.96000
25.28000
25.28000
6.32000
9.35000
25.44000
12.72000
23.84000
42.83000
31.82000
253.12000
73.47000
31.68000
12.66000
23.28000
15.52000
11.64000
0.00000
6.06000
24.91000
38.81000
23.08000
1.64000
6.56000
4.80000
6.56000
6.15000
10.66000
4.80000
2.40000
126.48000
1.84000
22.19000
33.12000
6.16000
35.75000
12.13000
24.99000
39.82000
21.01000
24.95000
26.97000
35.28000
53.04000
12.00000
21.72000
25.79000
0.00000
16.59000
14.28000
6.32000
15.91000
54.00000
57.00000
22.80000
20.33000
2.36000
19.70000
39.20000
14.77000
0.00000
1.82000
37.95000
36.80000
32.59000
27.60000
51.20000
17.15000
15.41000
3.43000
37.73000
16.40000
21.98000
36.08000
28.01000
3.86000
26.00000
30.00000
13.99000
18.65000
19.82000
48.00000
21.23000
29.48000
42.00000
33.25000
44.55000
76.00000
41.50000
8.30000
64.60000
37.27000
6.47000
31.52000
8.08000
6.32000
34.40000
32.38000
18.49000
49.31000
27.74000
55.20000
33.90000
34.80000
40.32000
3.84000
40.96000
37.14000
34.40000
41.40000
20.94000
7.31000
25.28000
6.79000
0.00000
30.10000
0.00000
28.00000
14.74000
27.72000
13.52000
33.07000
4.20000
4.35000
20.52000
15.22000
17.77000
5.29000
4.56000
45.44000
17.77000
27.20000
21.76000
15.62000
52.16000
3.40000
13.44000
25.28000
8.40000
49.30000
15.12000
15.90000
47.88000
29.04000
23.76000
5.28000
22.78000
27.96000
28.56000
14.07000
12.66000
36.40000
0.00000
3.40000
34.80000
24.64000
26.90000
12.70000
2.41000
20.96000
16.12000
5.29000
15.01000
9.53000
10.59000
11.44000
9.35000
4.25000
4.20000
3.36000
15.73000
14.22000
6.32000
13.44000
42.75000
0.00000
27.91000
27.91000
36.34000
1.93000
0.00000
10.66000
7.91000
17.80000
40.64000
3.84000
20.58000
14.82000
17.44000
44.49000
36.71000
110.64000
2.36000
18.87000
15.52000
34.38000
29.07000
14.00000
21.98000
29.74000
26.80000
28.30000
30.00000
26.80000
16.75000
50.32000
23.04000
27.84000
11.66000
12.86000
4.29000
19.57000
30.31000
17.75000
31.50000
7.00000
38.61000
21.10000
14.74000
2.05000
7.68000
24.57000
21.98000
16.50000
33.60000
22.51000
14.55000
39.27000
46.20000
60.69000
26.20000
5.29000
25.52000
18.96000
24.14000
11.35000
30.44000
23.29000
6.32000
6.66000
10.08000
5.72000
12.64000
0.85000
4.25000
18.70000
11.40000
14.50000
1.68000
18.48000
17.38000
12.64000
31.82000
33.44000
19.69000
37.76000
20.95000
26.11000
16.62000
-37.58000
18.97000
15.82000
40.64000
0.00000
50.60000
3.91000
21.85000
40.96000
38.08000
41.40000
34.40000
21.49000
5.29000
14.02000
25.50000
25.44000
4.47000
8.45000
29.05000
68.57000
41.71000
14.91000
42.75000
0.00000
33.25000
99.60000
80.10000
74.40000
0.00000
32.16000
23.04000
19.40000
16.88000
7.03000
14.07000
28.51000
5.64000
24.62000
4.10000
6.30000
9.46000
33.20000
35.88000
3.68000
46.46000
9.00000
39.82000
15.76000
26.66000
30.87000
28.96000
30.81000
22.32000
31.20000
15.76000
29.23000
47.06000
13.44000
11.44000
8.90000
18.10000
6.47000
34.38000
3.82000
29.55000
16.68000
26.11000
10.40000
36.80000
5.12000
20.87000
27.74000
30.87000
26.11000
27.44000
34.82000
61.44000
34.54000
32.66000
1.42000
0.00000
17.54000
26.89000
25.28000
5.29000
52.96000
30.82000
42.75000
57.84000
13.35000
15.31000
19.80000
31.03000
6.54000
12.93000
3.82000
11.79000
30.40000
25.98000
40.48000
36.80000
20.88000
17.10000
20.69000
30.55000
9.65000
38.28000
6.52000
15.66000
12.16000
5.22000
2.14000
25.73000
2.34000
57.28000
25.02000
74.40000
37.35000
0.00000
101.84000
92.62000
0.00000
28.42000
18.05000
7.88000
13.03000
24.70000
0.00000
28.42000
30.27000
12.97000
0.00000
23.16000
17.73000
9.05000
6.90000
3.60000
1.07000
9.33000
11.74000
5.22000
50.22000
0.00000
10.10000
0.00000
0.00000
47.52000
13.36000
101.84000
76.00000
19.76000
9.00000
28.64000
27.00000
27.60000
15.52000
48.87000
18.40000
29.67000
37.29000
40.68000
9.77000
45.54000
0.00000
49.45000
4.00000
43.56000
17.20000
33.60000
14.17000
50.44000
32.36000
3.42000
6.20000
61.44000
26.59000
32.28000
18.96000
34.08000
14.20000
20.11000
25.28000
5.92000
19.56000
5.04000
13.44000
0.00000
2.52000
27.04000
0.00000
38.87000
16.08000
26.73000
11.26000
13.72000
19.78000
17.42000
12.64000
25.06000
50.56000
20.11000
5.68000
14.27000
16.94000
2.37000
13.60000
4.20000
1.58000
10.08000
16.15000
13.05000
13.44000
8.70000
0.00000
6.72000
27.80000
8.30000
80.18000
19.78000
26.24000
14.08000
0.00000
19.94000
31.57000
20.32000
20.42000
24.35000
4.74000
71.14000
8.34000
15.84000
27.58000
23.40000
9.75000
9.84000
5.73000
3.94000
24.57000
4.82000
56.32000
40.00000
7.50000
13.99000
35.50000
14.44000
0.00000
0.00000
17.50000
26.25000
0.00000
50.22000
26.25000
0.00000
4.51000
21.00000
5.80000
3.96000
10.44000
10.45000
25.20000
15.03000
26.73000
8.50000
13.80000
23.70000
3.95000
2.85000
12.64000
46.78000
17.38000
15.95000
5.04000
20.40000
10.08000
13.44000
6.72000
4.20000
3.16000
10.08000
4.20000
17.38000
52.25000
64.24000
40.42000
24.92000
27.74000
19.78000
6.90000
33.10000
41.81000
34.80000
9.60000
10.79000
15.44000
17.55000
11.36000
18.96000
1.90000
30.60000
18.08000
16.20000
9.00000
8.45000
6.84000
12.60000
10.37000
42.83000
12.11000
0.00000
7.05000
57.10000
38.00000
60.47000
42.83000
60.47000
103.50000
52.25000
52.83000
10.58000
64.64000
56.96000
74.81000
35.78000
112.36000
44.54000
55.44000
35.26000
4.00000
46.20000
22.51000
6.30000
16.60000
14.55000
5.43000
14.55000
1.50000
7.14000
16.88000
25.04000
18.49000
12.42000
9.70000
35.80000
9.96000
28.96000
21.66000
29.23000
15.96000
33.20000
38.19000
13.35000
44.49000
76.00000
30.72000
40.48000
27.12000
0.00000
73.60000
36.80000
26.26000
12.64000
18.22000
11.85000
32.40000
33.20000
18.60000
12.45000
50.92000
28.95000
51.22000
8.12000
7.04000
20.98000
13.99000
8.69000
12.75000
0.79000
2.52000
5.04000
27.84000
13.44000
7.56000
6.72000
32.84000
27.60000
15.07000
32.32000
35.19000
4.92000
2.46000
3.30000
2.46000
12.98000
24.00000
13.12000
29.48000
20.69000
29.92000
11.52000
29.40000
65.00000
8.37000
24.66000
25.60000
25.60000
78.85000
9.30000
29.05000
69.51000
29.05000
23.75000
62.25000
109.25000
21.12000
20.48000
17.60000
2.59000
3.54000
27.16000
10.81000
40.48000
22.00000
28.16000
15.44000
14.15000
38.25000
2.33000
3.48000
31.68000
14.00000
17.00000
14.00000
10.00000
30.51000
32.00000
4.45000
31.50000
70.55000
73.20000
53.40000
29.48000
28.20000
39.20000
9.20000
34.80000
0.00000
18.28000
16.62000
29.67000
40.96000
5.93000
32.66000
12.64000
9.58000
6.70000
13.39000
5.16000
15.28000
10.34000
33.60000
14.07000
11.68000
53.76000
32.64000
24.21000
11.36000
21.88000
5.82000
9.29000
32.66000
32.16000
16.51000
5.10000
24.64000
27.20000
19.05000
19.32000
7.90000
16.53000
45.76000
8.40000
7.20000
28.80000
13.68000
0.00000
37.18000
40.59000
14.08000
10.34000
13.09000
28.56000
23.29000
28.40000
4.74000
9.77000
2.84000
25.28000
28.44000
9.58000
8.40000
3.95000
11.44000
1.70000
25.28000
10.92000
20.40000
13.44000
8.40000
6.72000
20.16000
30.59000
16.87000
61.44000
26.20000
3.43000
36.98000
40.48000
40.48000
36.02000
34.80000
40.64000
52.90000
30.72000
36.80000
6.03000
25.41000
35.60000
48.48000
33.20000
31.15000
27.80000
17.64000
71.20000
10.81000
47.64000
10.81000
29.88000
43.93000
23.28000
13.46000
7.04000
34.00000
55.20000
42.50000
27.84000
3.50000
4.44000
4.44000
28.00000
37.84000
19.93000
30.69000
0.00000
9.44000
28.00000
28.00000
6.56000
3.28000
28.16000
25.96000
0.00000
29.99000
4.22000
35.70000
22.51000
12.06000
7.03000
4.20000
21.57000
1.90000
23.10000
8.47000
23.78000
3.16000
32.66000
29.34000
22.72000
26.98000
4.08000
1.68000
13.43000
18.17000
4.35000
30.59000
28.45000
5.08000
58.42000
20.80000
5.15000
15.52000
3.08000
23.00000
2.84000
8.47000
27.04000
27.04000
0.00000
11.92000
89.22000
15.91000
69.34000
84.19000
73.20000
42.83000
71.25000
84.55000
70.01000
39.26000
30.00000
21.44000
27.30000
15.77000
3.64000
3.64000
18.91000
19.40000
4.10000
2.90000
11.04000
19.51000
14.48000
0.00000
2.43000
6.06000
10.98000
29.58000
28.96000
26.64000
21.72000
31.52000
15.80000
12.64000
7.56000
10.20000
14.28000
7.39000
21.41000
95.45000
5.91000
2.55000
52.53000
3.28000
27.23000
12.65000
5.15000
3.48000
30.87000
25.71000
40.96000
53.97000
26.00000
15.32000
7.59000
34.80000
20.23000
10.86000
8.47000
37.92000
23.29000
13.44000
11.44000
4.74000
41.34000
49.80000
20.75000
41.50000
3.54000
3.88000
30.56000
8.98000
104.96000
26.05000
5.91000
28.16000
30.88000
8.29000
14.08000
28.65000
30.88000
28.16000
7.48000
18.65000
25.60000
11.66000
9.33000
11.05000
31.84000
23.35000
54.88000
61.74000
24.24000
13.12000
7.80000
3.69000
6.56000
6.15000
13.32000
37.12000
9.38000
2.40000
3.30000
2.15000
10.56000
6.88000
39.45000
22.08000
3.13000
8.40000
32.05000
10.14000
9.95000
22.32000
14.55000
0.00000
0.00000
10.15000
55.20000
4.10000
3.69000
4.80000
10.25000
20.02000
26.64000
20.54000
15.80000
10.20000
8.40000
21.84000
2.37000
2.52000
3.95000
1.43000
26.88000
22.08000
13.44000
15.76000
3.94000
11.82000
21.72000
17.91000
39.82000
27.06000
18.09000
16.94000
3.00000
4.80000
18.24000
33.83000
3.81000
9.36000
84.00000
43.20000
12.00000
3.44000
6.00000
9.60000
2.90000
9.20000
44.16000
36.75000
34.17000
32.16000
43.44000
5.43000
6.33000
23.88000
4.20000
10.08000
11.60000
13.60000
3.95000
12.60000
26.88000
15.96000
13.44000
8.40000
3.16000
9.86000
34.50000
23.04000
3.92000
3.11000
31.84000
10.47000
6.15000
9.84000
27.60000
5.15000
27.74000
40.64000
8.07000
40.80000
6.32000
13.92000
6.72000
7.03000
11.70000
4.62000
50.60000
32.77000
18.49000
25.52000
7.10000
2.84000
2.13000
6.11000
3.55000
36.92000
12.70000
14.45000
13.03000
26.98000
33.88000
4.20000
9.57000
10.27000
8.50000
13.60000
24.31000
34.50000
20.16000
11.10000
6.79000
31.84000
25.79000
27.89000
2.43000
19.60000
14.55000
47.06000
3.81000
11.42000
10.25000
44.60000
32.30000
25.52000
15.22000
1.50000
13.12000
1.28000
0.96000
0.36000
0.12000
0.00000
1.56000


But I'm also getting the following error:
Msg 8114, Level 16, State 5, Line 1
Error converting data type varchar to numeric.


What can I do?
LVL 1
isamesAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Lee SavidgeCommented:
Well, firstly, not pasting the entier recordset!

I can't see the purpose of the case.

Select SalesImportHistoryV2.RSID_EXTENDED
from SalesImportHistoryV2
where SalesImportHistoryV2.RSID_TYPE = 'R'

Open in new window

Vitor MontalvãoMSSQL Senior EngineerCommented:
What's the type of SalesImportHistoryV2.RSID_EXTENDED?
If it's numeric you can't use the part:
    ELSE ''

Use NULL instead:
Select
 Case
 When SalesImportHistoryV2.RSID_TYPE = 'R'
 Then SalesImportHistoryV2.RSID_EXTENDED
 Else NULL
 End
 from SalesImportHistoryV2

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vikas GargAssociate Principal EngineerCommented:
Hi,

Try this

Select
Case
When SalesImportHistoryV2.RSID_TYPE = 'R'
Then Convert(varchar(50),SalesImportHistoryV2.RSID_EXTENDED)
Else ''
End
from SalesImportHistoryV2
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.