Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 row into coloumn in SQL

Author  Topic 

soofihussain
Starting Member

11 Posts

Posted - 2014-05-25 : 04:42:52
Hi
I have multiple number of rows i want to change into column wise. My data

PondCrop DOC ABW TargetABW
01PA01-18 7 0 0.21
01PA01-18 15 0.59 0.77
01PA01-18 22 1.24 1.5
01PA01-18 28 0.92 2.6
01PA01-18 35 1.82 3.7
01PA01-18 42 2.6 4.8
01PA01-18 49 3.62 5.9
01PA01-18 56 4.64 7
01PA01-18 63 5.54 8.1
01PA01-18 66 6.24 8.1
01PA01-18 73 7.25 9.2
01PA02-18 7 0 0.21
01PA02-18 15 0.59 0.77
01PA02-18 22 1.24 1.5
01PA02-18 28 0.87 2.6
01PA02-18 35 1.8 3.7
01PA02-18 42 2.4 4.8
01PA02-18 49 3.51 5.9
01PA02-18 56 4.6 7
01PA02-18 63 5.51 8.1
01PA02-18 66 6.53 8.1
01PA02-18 73 7.42 9.2
01PA03-18 14 0.53 0.77
01PA03-18 21 1.14 1.5
01PA03-18 27 0.91 1.5
01PA03-18 34 1.67 2.6
01PA03-18 41 2.2 3.7
01PA03-18 48 3.24 4.8
01PA03-18 55 4.31 5.9
01PA03-18 62 4.94 7
01PA03-18 65 5.44 8.1
01PA03-18 72 6.41 9.2
01PA04-18 14 0.53 0.77
01PA04-18 21 1.14 1.5
01PA04-18 27 0.9 1.5
01PA04-18 34 1.52 2.6
01PA04-18 41 1.9 3.7
01PA04-18 48 2.6 4.8
01PA04-18 55 3.52 5.9
01PA04-18 62 4.21 7
01PA04-18 65 4.82 8.1
01PA04-18 72 5.87 9.2
01PA05-18 14 0.53 0.77
01PA05-18 21 1.14 1.5
01PA05-18 27 0.92 1.5
01PA05-18 34 1.49 2.6
01PA05-18 41 1.91 3.7
01PA05-18 48 2.64 4.8
01PA05-18 55 3.69 5.9
01PA05-18 62 4.19 7
01PA05-18 65 4.72 8.1
01PA05-18 72 5.74 9.2
01PA06-18 13 0.48 0.21
01PA06-18 20 1.04 0.77
01PA06-18 26 0.74 1.5
01PA06-18 33 1.25 2.6
01PA06-18 40 1.82 3.7
01PA06-18 47 3.12 4.8
01PA06-18 54 4.4 5.9
01PA06-18 61 5.44 7
01PA06-18 64 6.46 8.1
01PA06-18 71 7.3 9.2
01PA07-18 13 0.48 0.21
01PA07-18 20 1.04 0.77
01PA07-18 26 0.72 1.5
01PA07-18 33 1.32 2.6
01PA07-18 40 1.84 3.7
01PA07-18 47 3.05 4.8
01PA07-18 54 4.12 5.9
01PA07-18 61 5.21 7
01PA07-18 64 6 8.1
01PA07-18 71 6.9 9.2
01PA08-18 13 0.48 0.21
01PA08-18 20 1.04 0.77
01PA08-18 26 0.7 1.5
01PA08-18 33 1.3 2.6
01PA08-18 40 1.8 3.7
01PA08-18 47 3.07 4.8
01PA08-18 54 3.72 5.9
01PA08-18 61 4.52 7
01PA08-18 64 5.11 8.1
01PA08-18 71 5.87 9.2
01PA09-18 13 0.48 0.21
01PA09-18 20 1.04 0.77
01PA09-18 26 0.71 1.5
01PA09-18 33 1.22 2.6
01PA09-18 40 1.85 3.7
01PA09-18 47 2.9 4.8
01PA09-18 54 3.74 5.9
01PA09-18 61 4.4 7
01PA09-18 64 4.92 8.1
01PA09-18 71 5.78 9.2
01PB01-19 8 0 0.21
01PB01-19 15 0 0.77
01PB01-19 23 0.94 1.5
01PB01-19 30 1.85 2.6
01PB01-19 36 2.5 3.7
01PB01-19 43 3.1 4.8
01PB01-19 50 3.74 5.9
01PB01-19 57 5.05 7
01PB01-19 64 6.18 8.1
01PB01-19 71 7.03 9.2
01PB01-19 74 7.87 9.2
01PB01-19 81 8.41 10.3
01PB02-19 8 0 0.21
01PB02-19 15 0 0.77
01PB02-19 23 0.98 1.5
01PB02-19 30 1.82 2.6
01PB02-19 36 2.6 3.7
01PB02-19 43 3.4 4.8
01PB02-19 50 4 5.9
01PB02-19 57 5.5 7
01PB02-19 64 6.72 8.1
01PB02-19 71 7.5 9.2
01PB02-19 74 8.43 9.2
01PB02-19 81 9.6 10.3
01PB03-19 8 0 0.21
01PB03-19 15 0 0.77
01PB03-19 23 0.92 1.5
01PB03-19 30 1.88 2.6
01PB03-19 36 2.51 3.7
01PB03-19 43 3 4.8
01PB03-19 50 3.4 5.9
01PB03-19 57 5.03 7
01PB03-19 64 6.27 8.1
01PB03-19 71 7.32 9.2
01PB03-19 74 8.2 9.2
01PB03-19 81 9.6 10.3
01PB04-19 13 0 0.21
01PB04-19 21 1.14 1.5
01PB04-19 28 0.93 2.6
01PB04-19 34 1.3 2.6
01PB04-19 41 2.1 3.7
01PB04-19 48 2.9 4.8
01PB04-19 55 3.7 5.9
01PB04-19 62 4.49 7
01PB04-19 69 5.3 8.1
01PB04-19 72 6.08 9.2
01PB04-19 79 7.55 10.3
01PB05-19 13 0 0.21
01PB05-19 21 1.14 1.5
01PB05-19 28 0.83 2.6
01PB05-19 34 1.41 2.6
01PB05-19 41 1.9 3.7
01PB05-19 48 2.6 4.8
01PB05-19 55 3.37 5.9
01PB05-19 62 4.32 7
01PB05-19 69 5.03 8.1
01PB05-19 72 5.84 9.2
01PB05-19 79 6.9 10.3
01PB06-19 13 0 0.21
01PB06-19 21 1.14 1.5
01PB06-19 28 0.86 2.6
01PB06-19 34 1.4 2.6
01PB06-19 41 2.2 3.7
01PB06-19 48 2.9 4.8
01PB06-19 55 3.5 5.9
01PB06-19 62 4.61 7
01PB06-19 69 5.3 8.1
01PB06-19 72 6.18 9.2
01PB06-19 79 7.06 10.3
01PB07-19 12 0 0.21
01PB07-19 20 1.04 0.77
01PB07-19 27 0.85 1.5
01PB07-19 33 1.06 2.6
01PB07-19 40 1.96 3.7
01PB07-19 47 2.6 4.8
01PB07-19 54 3.45 5.9
01PB07-19 61 4.23 7
01PB07-19 68 5.04 8.1
01PB07-19 71 5.85 9.2
01PB07-19 78 6.7 10.3
01PB08-19 12 0 0.21
01PB08-19 20 1.04 0.77
01PB08-19 27 0.85 1.5
01PB08-19 33 1.2 2.6
01PB08-19 40 1.9 3.7
01PB08-19 47 2.7 4.8
01PB08-19 54 3.62 5.9
01PB08-19 61 4.49 7
01PB08-19 68 5.13 8.1
01PB08-19 71 6 9.2
01PB08-19 78 6.9 10.3
01PB09-19 12 0 0.21
01PB09-19 20 1.04 0.77
01PB09-19 27 0.78 1.5
01PB09-19 33 1.4 2.6
01PB09-19 40 2 3.7
01PB09-19 47 2.7 4.8
01PB09-19 54 3.86 5.9
01PB09-19 61 5.47 7
01PB09-19 68 6.03 8.1
01PB09-19 71 6.9 9.2
01PB09-19 78 7.5 10.3
01PC01-19 8 0 0.21
01PC01-19 15 0 0.77
01PC01-19 23 1.34 1.5
01PC01-19 30 1.77 2.6
01PC01-19 36 2.1 3.7
01PC01-19 43 3.2 4.8
01PC01-19 50 3.7 5.9
01PC01-19 57 4.6 7
01PC01-19 64 5.5 8.1
01PC01-19 71 6 9.2
01PC01-19 74 7 9.2
01PC01-19 81 7.4 10.3
01PC02-19 7 0 0.21
01PC02-19 14 0 0.77
01PC02-19 22 1.24 1.5
01PC02-19 29 1.56 2.6
01PC02-19 35 2.4 3.7
01PC02-19 42 3.1 4.8
01PC02-19 49 3.5 5.9
01PC02-19 56 4.34 7
01PC02-19 63 5.3 8.1
01PC02-19 70 6.2 9.2
01PC02-19 73 7 9.2
01PC02-19 80 7.85 10.3
01PC03-19 7 0 0.21
01PC03-19 14 0 0.77
01PC03-19 22 1.24 1.5
01PC03-19 29 1.62 2.6
01PC03-19 35 2.2 3.7
01PC03-19 42 2.6 4.8
01PC03-19 49 3.1 5.9
01PC03-19 56 4.1 7
01PC03-19 63 5 8.1
01PC03-19 70 5.9 9.2
01PC03-19 73 6.5 9.2
01PC03-19 80 7.6 10.3
01PC04-20 13 0 0.21
01PC04-20 21 1.14 1.5
01PC04-20 28 0.81 2.6
01PC04-20 34 1.5 2.6
01PC04-20 41 2.2 3.7
01PC04-20 48 2.9 4.8
01PC04-20 55 3.4 5.9
01PC04-20 62 4.5 7
01PC04-20 69 5 8.1
01PC04-20 72 6 9.2
01PC04-20 79 6.9 10.3
01PC05-19 13 0 0.21
01PC05-19 21 1.14 1.5
01PC05-19 28 0.88 2.6
01PC05-19 34 1.22 2.6
01PC05-19 41 2 3.7
01PC05-19 48 2.54 4.8
01PC05-19 55 3.1 5.9
01PC05-19 62 4.2 7
01PC05-19 69 4.6 8.1
01PC05-19 72 5.5 9.2
01PC05-19 79 6.2 10.3
01PC06-19 11 0 0.21
01PC06-19 19 0.94 0.77
01PC06-19 26 0.85 1.5
01PC06-19 32 1.05 2.6
01PC06-19 39 2.3 3.7
01PC06-19 46 2.9 4.8
01PC06-19 53 3.8 5.9
01PC06-19 60 4.3 7
01PC06-19 67 5 8.1
01PC06-19 70 5.8 9.2
01PC06-19 77 6.8 10.3
01PC07-19 11 0 0.21
01PC07-19 19 0.94 0.77
01PC07-19 26 0.79 1.5
01PC07-19 32 1.4 2.6
01PC07-19 39 1.98 3.7
01PC07-19 46 2.7 4.8
01PC07-19 53 3 5.9
01PC07-19 60 3.9 7
01PC07-19 67 5 8.1
01PC07-19 70 5.6 9.2
01PC07-19 77 6.14 10.3
01PC08-19 11 0 0.21
01PC08-19 19 0.94 0.77
01PC08-19 26 0.9 1.5
01PC08-19 32 1.2 2.6
01PC08-19 39 2 3.7
01PC08-19 46 2.5 4.8
01PC08-19 53 3 5.9
01PC08-19 60 4.1 7
01PC08-19 67 4.91 8.1
01PC08-19 70 5.5 9.2
01PC08-19 77 6 10.3
01PC09-20 11 0 0.21
01PC09-20 19 0.94 0.77
01PC09-20 26 0.8 1.5
01PC09-20 32 1.2 2.6
01PC09-20 39 1.95 3.7
01PC09-20 46 2.65 4.8
01PC09-20 53 3 5.9
01PC09-20 60 4.18 7
01PC09-20 67 5 8.1
01PC09-20 70 5.8 9.2
01PC09-20 77 6.4 10.3
01PD01-09 10 0 0.21
01PD01-09 18 0.84 0.77
01PD01-09 25 0.78 1.5
01PD01-09 31 1.02 2.6
01PD01-09 38 1.92 3.7
01PD01-09 45 2.52 4.8
01PD01-09 52 3.4 5.9
01PD01-09 59 4.11 7
01PD01-09 66 5.03 8.1
01PD01-09 69 5.7 8.1
01PD01-09 76 6.7 9.2
01PD02-09 10 0 0.21
01PD02-09 18 0.84 0.77
01PD02-09 25 0.8 1.5
01PD02-09 31 1.03 2.6
01PD02-09 38 1.88 3.7
01PD02-09 45 2.47 4.8
01PD02-09 52 3.33 5.9
01PD02-09 59 4.04 7
01PD02-09 66 4.85 8.1
01PD02-09 69 5.6 8.1
01PD02-09 76 6.45 9.2
01PD03-09 10 0 0.21
01PD03-09 18 0.84 0.77
01PD03-09 25 0.81 1.5
01PD03-09 31 0.99 2.6
01PD03-09 38 1.8 3.7
01PD03-09 45 2.45 4.8
01PD03-09 52 3.14 5.9
01PD03-09 59 4.01 7
01PD03-09 66 4.91 8.1
01PD03-09 69 5.5 8.1
01PD03-09 76 6.5 9.2
01PD04-09 8 0 0.21
01PD04-09 16 0.64 0.77
01PD04-09 23 0.67 1.5
01PD04-09 29 0.96 2.6
01PD04-09 36 1.9 3.7
01PD04-09 43 2.53 4.8
01PD04-09 50 3.26 5.9
01PD04-09 57 4.38 7
01PD04-09 64 5.42 8.1
01PD04-09 67 6.03 8.1
01PD04-09 74 6.6 9.2
01PD05-09 8 0 0.21
01PD05-09 16 0.64 0.77
01PD05-09 23 0.7 1.5
01PD05-09 29 1.02 2.6
01PD05-09 36 2.07 3.7
01PD05-09 43 2.72 4.8
01PD05-09 50 3.6 5.9
01PD05-09 57 4.56 7
01PD05-09 64 5.52 8.1
01PD05-09 67 6.2 8.1
01PD05-09 74 6.9 9.2
01PD08-09 8 0 0.21
01PD08-09 16 0.64 0.77
01PD08-09 23 0.86 1.5
01PD08-09 29 1.34 2.6
01PD08-09 36 2.23 3.7
01PD08-09 43 2.77 4.8
01PD08-09 50 3.79 5.9
01PD08-09 57 4.59 7
01PD08-09 64 5.62 8.1
01PD08-09 67 5.97 8.1
01PD08-09 74 7 9.2
01PD09-09 8 0 0.21
01PD09-09 16 0.64 0.77
01PD09-09 23 0.82 1.5
01PD09-09 29 1.34 2.6
01PD09-09 36 2.35 3.7
01PD09-09 43 2.79 4.8
01PD09-09 50 3.82 5.9
01PD09-09 57 4.64 7
01PD09-09 64 5.65 8.1
01PD09-09 67 6.04 8.1
01PD09-09 74 7.04 9.2
01PD10-10 14 0.53 0.77
01PD10-10 21 1.14 1.5
01PD10-10 27 0.89 1.5
01PD10-10 34 1.69 2.6
01PD10-10 41 2.31 3.7
01PD10-10 48 3.14 4.8
01PD10-10 55 4.2 5.9
01PD10-10 62 5.22 7
01PD10-10 65 5.82 8.1
01PD10-10 72 6.84 9.2
03PA01-17 11 0.37 0.21
03PA01-17 18 0.84 0.77
03PA01-17 24 0.75 1.5
03PA01-17 31 1.65 2.6
03PA01-17 38 2.5 3.7
03PA01-17 45 3.45 4.8
03PA01-17 52 4.1 5.9
03PA01-17 59 4.56 7
03PA01-17 62 4.8 7
03PA01-17 69 5.6 8.1
03PA02-17 11 0.37 0.21
03PA02-17 18 0.84 0.77
03PA02-17 24 0.55 1.5
03PA02-17 31 1.5 2.6
03PA02-17 38 2.3 3.7
03PA02-17 45 3.3 4.8
03PA02-17 52 4.4 5.9
03PA02-17 59 5.06 7
03PA02-17 62 5.5 7
03PA02-17 69 6.4 8.1
03PA03-17 11 0.37 0.21
03PA03-17 18 0.84 0.77
03PA03-17 24 0.65 1.5
03PA03-17 31 1.7 2.6
03PA03-17 38 2.16 3.7
03PA03-17 45 3.1 4.8
03PA03-17 52 4.3 5.9
03PA03-17 59 6.14 7
03PA03-17 62 6.5 7
03PA03-17 69 7.3 8.1
03PA04-16 11 0.37 0.21
03PA04-16 18 0.84 0.77
03PA04-16 24 0.45 1.5
03PA04-16 31 1.4 2.6
03PA04-16 38 2.1 3.7
03PA04-16 45 2.95 4.8
03PA04-16 52 4 5.9
03PA04-16 59 4.23 7
03PA04-16 62 4.7 7
03PA04-16 69 5.6 8.1
03PA05-16 9 0.26 0.21
03PA05-16 16 0.64 0.77
03PA05-16 22 1.34 1.5
03PA05-16 29 1.35 2.6
03PA05-16 36 2.2 3.7
03PA05-16 43 3.15 4.8
03PA05-16 50 3.9 5.9
03PA05-16 57 4.46 7
03PA05-16 60 4.8 7
03PA05-16 67 5.8 8.1
03PA06-16 7 0.19 0.21
03PA06-16 14 0.53 0.77
03PA06-16 20 1.14 0.77
03PA06-16 27 0.65 1.5
03PA06-16 34 1.4 2.6
03PA06-16 41 2.6 3.7
03PA06-16 48 3.7 4.8
03PA06-16 55 4.44 5.9
03PA06-16 58 4.85 7
03PA06-16 65 6 8.1
03PA07-16 8 0.22 0.21
03PA07-16 14 0.59 0.77
03PA07-16 21 0.55 1.5
03PA07-16 28 1.25 2.6
03PA07-16 35 2.4 3.7
03PA07-16 42 3.5 4.8
03PA07-16 49 4.18 5.9
03PA07-16 52 4.55 5.9
03PA07-16 59 5.7 7
03PA08-17 8 0.22 0.21
03PA08-17 14 0.59 0.77
03PA08-17 21 0.68 1.5
03PA08-17 28 1.5 2.6
03PA08-17 35 2.65 3.7
03PA08-17 42 3.9 4.8
03PA08-17 49 5.3 5.9
03PA08-17 52 5.8 5.9
03PA08-17 59 7.6 7
03PB02-16 7 0.19 0.21
03PB02-16 14 0.53 0.77
03PB02-16 20 1.14 0.77
03PB02-16 27 0.7 1.5
03PB02-16 34 1.6 2.6
03PB02-16 41 2.6 3.7
03PB02-16 48 3 4.8
03PB02-16 55 4.22 5.9
03PB02-16 58 4.65 7
03PB02-16 65 5.8 8.1
03PB05-16 13 0.48 0.21
03PB05-16 19 1.04 0.77
03PB05-16 26 0.9 1.5
03PB05-16 33 1.5 2.6
03PB05-16 40 2.5 3.7
03PB05-16 47 3.1 4.8
03PB05-16 54 3.78 5.9
03PB05-16 57 4.45 7
03PB05-16 64 5.6 8.1
03PB06-16 13 0.48 0.21
03PB06-16 19 1.04 0.77
03PB06-16 26 0.9 1.5
03PB06-16 33 1.7 2.6
03PB06-16 40 2.5 3.7
03PB06-16 47 3 4.8
03PB06-16 54 3.47 5.9
03PB06-16 57 4.1 7
03PB06-16 64 5 8.1
03PB07-16 13 0.48 0.21
03PB07-16 19 1.04 0.77
03PB07-16 26 0.7 1.5
03PB07-16 33 1.6 2.6
03PB07-16 40 2.4 3.7
03PB07-16 47 3 4.8
03PB07-16 54 3.5 5.9
03PB07-16 57 4 7
03PB07-16 64 4.8 8.1
03PB08-15 12 0.42 0.21
03PB08-15 18 0.94 0.77
03PB08-15 25 0.9 1.5
03PB08-15 32 1.5 2.6
03PB08-15 39 2.6 3.7
03PB08-15 46 3.1 4.8
03PB08-15 53 5.66 5.9
03PB08-15 56 6.1 7
03PB08-15 63 7 8.1
03PC01-16 7 0.22 0.21
03PC01-16 10 0.37 0.21
03PC01-16 17 0.84 0.77
03PC02-16 12 0.42 0.21
03PC02-16 18 0.94 0.77
03PC02-16 25 1.01 1.5
03PC02-16 32 1.73 2.6
03PC02-16 39 2.59 3.7
03PC02-16 46 3.25 4.8
03PC02-16 53 3.82 5.9
03PC02-16 56 4.15 7
03PC02-16 63 5.33 8.1
03PC03-16 9 0.26 0.21
03PC03-16 15 0.64 0.77
03PC03-16 22 1.01 1.5
03PC03-16 29 1.84 2.6
03PC03-16 36 2.31 3.7
03PC03-16 43 3.32 4.8
03PC03-16 50 4.77 5.9
03PC03-16 53 5.1 5.9
03PC03-16 60 5.57 7
03PC04-15 9 0.26 0.21
03PC04-15 15 0.64 0.77
03PC04-15 22 0.99 1.5
03PC04-15 29 1.83 2.6
03PC04-15 36 2.25 3.7
03PC04-15 43 3.23 4.8
03PC04-15 50 4.82 5.9
03PC04-15 53 5.2 5.9
03PC04-15 60 5.64 7
03PC05-15 11 0.42 0.21
03PC05-15 18 0.94 0.77
03PC05-15 25 0.83 1.5
03PC05-15 32 1.5 2.6
03PC05-15 39 2.28 3.7
03PC05-15 46 2.92 4.8
03PC05-15 49 3.3 5.9
03PC05-15 56 3.55 7
03PC06-16 11 0.42 0.21
03PC06-16 18 0.94 0.77
03PC06-16 25 0.84 1.5
03PC06-16 32 1.53 2.6
03PC06-16 39 2.69 3.7
03PC06-16 46 3.82 4.8
03PC06-16 49 4.3 5.9
03PC06-16 56 5.37 7
03PC07-15 12 0.42 0.21
03PC07-15 18 0.94 0.77
03PC07-15 25 0.99 1.5
03PC07-15 32 1.82 2.6
03PC07-15 39 2.65 3.7
03PC07-15 46 3.04 4.8
03PC07-15 53 3.45 5.9
03PC07-15 56 3.9 7
03PC07-15 63 4.77 8.1
03PC08-14 11 0.37 0.21
03PC08-14 17 0.84 0.77
03PC08-14 24 0.99 1.5
03PC08-14 31 1.75 2.6
03PC08-14 38 2.45 3.7
03PC08-14 45 3.07 4.8
03PC08-14 52 3.45 5.9
03PC08-14 55 3.95 5.9
03PC08-14 62 4.72 7
03PD01-14 7 0.19 0.21
03PD01-14 13 0.53 0.21
03PD01-14 20 1.14 0.77
03PD01-14 27 0.7 1.5
03PD01-14 34 1.75 2.6
03PD01-14 41 2.64 3.7
03PD01-14 48 3.49 4.8
03PD01-14 51 4.2 5.9
03PD01-14 58 5.2 7
03PD02-14 7 0.19 0.21
03PD02-14 13 0.53 0.21
03PD02-14 20 1.14 0.77
03PD02-14 27 0.85 1.5
03PD02-14 34 1.85 2.6
03PD02-14 41 2.85 3.7
03PD02-14 48 5.35 4.8
03PD02-14 51 5.5 5.9
03PD02-14 58 6.5 7
03PD03-14 11 0.37 0.21
03PD03-14 17 0.84 0.77
03PD03-14 24 0.78 1.5
03PD03-14 31 1.78 2.6
03PD03-14 38 2.55 3.7
03PD03-14 45 3.43 4.8
03PD03-14 52 5.2 5.9
03PD03-14 55 5.4 5.9
03PD03-14 62 6.2 7
03PD04-14 9 0.26 0.21
03PD04-14 15 0.64 0.77
03PD04-14 22 0.65 1.5
03PD04-14 29 1.84 2.6
03PD04-14 36 2.62 3.7
03PD04-14 43 3.38 4.8
03PD04-14 50 5.51 5.9
03PD04-14 53 5.85 5.9
03PD04-14 60 6.95 7
03PD05-15 7 0.19 0.21
03PD05-15 13 0.53 0.21
03PD05-15 20 1.14 0.77
03PD05-15 27 0.55 1.5
03PD05-15 34 1.53 2.6
03PD05-15 41 2.7 3.7
03PD05-15 48 3.57 4.8
03PD05-15 51 4.1 5.9
03PD05-15 58 5.1 7
03PD06-14 9 0.26 0.21
03PD06-14 15 0.64 0.77
03PD06-14 22 0.6 1.5
03PD06-14 29 1.7 2.6
03PD06-14 36 2.76 3.7
03PD06-14 43 3.37 4.8
03PD06-14 50 4.36 5.9
03PD06-14 53 4.7 5.9
03PD06-14 60 5.6 7
03PD07-15 7 0.22 0.21
03PD07-15 10 0.37 0.21
03PD07-15 17 0.84 0.77
03PD08-15 9 0.26 0.21
03PD08-15 15 0.64 0.77
03PD08-15 22 0.7 1.5
03PD08-15 29 1.85 2.6
03PD08-15 36 2.65 3.7
03PD08-15 43 3.4 4.8
03PD08-15 50 5.15 5.9
03PD08-15 53 5.6 5.9
03PD08-15 60 6.6 7
05PA05-13 11 0 0.21
05PA05-13 17 0 0.77
05PA05-13 24 0 1.5
05PA05-13 25 0 1.5
05PB01-14 9 0 0.21
05PB01-14 9 0 0.21
05PB01-14 22 1.4 1.5
05PB01-14 30 2.4 2.6
06PA01-13 10 0.37 0.21
06PA01-13 17 0.84 0.77
06PA01-13 24 1.1 1.5
06PA01-13 31 2.3 2.6
06PA01-13 34 3.23 2.6
06PA01-13 41 4.61 3.7
06PA02-14 10 0.37 0.21
06PA02-14 17 0.84 0.77
06PA02-14 24 1 1.5
06PA02-14 31 2.1 2.6
06PA02-14 34 3.23 2.6
06PA02-14 41 4.1 3.7
06PA03-14 12 0.48 0.21
06PA03-14 19 1.04 0.77
06PA03-14 26 0.75 1.5
06PA03-14 29 2 2.6
06PA03-14 36 2.52 3.7
06PA04-13 12 0.48 0.21
06PA04-13 19 1.04 0.77
06PA04-13 26 0.82 1.5
06PA04-13 29 2.08 2.6
06PA04-13 36 2.6 3.7
06PA05-14 11 0.42 0.21
06PA05-14 18 0.94 0.77
06PA05-14 25 0.73 1.5
06PA05-14 28 2.16 2.6
06PA05-14 35 2.4 3.7
06PA06-14 11 0.42 0.21
06PA06-14 18 0.94 0.77
06PA06-14 25 0.81 1.5
06PA06-14 28 2.16 2.6
06PA06-14 35 2.8 3.7
06PA07-14 13 0.53 0.21
06PA07-14 20 1.14 0.77
06PA07-14 27 0.89 1.5
06PA07-14 30 2.09 2.6
06PA07-14 37 2.75 3.7
06PA08-14 13 0.53 0.21
06PA08-14 20 1.14 0.77
06PA08-14 27 0.91 1.5
06PA08-14 30 2.11 2.6
06PA08-14 37 2.82 3.7
06PB01-13 10 0.37 0.21
06PB01-13 17 0.84 0.77
06PB01-13 24 1 1.5
06PB01-13 31 2.2 2.6
06PB01-13 34 3.23 2.6
06PB01-13 41 4.48 3.7
06PB02-13 10 0.37 0.21
06PB02-13 17 0.84 0.77
06PB02-13 24 0.6 1.5
06PB02-13 31 1.61 2.6
06PB02-13 34 3.23 2.6
06PB02-13 41 3.5 3.7
06PB03-13 11 0.42 0.21
06PB03-13 18 0.94 0.77
06PB03-13 25 0.85 1.5
06PB03-13 28 2.16 2.6
06PB03-13 35 3 3.7
06PB04-13 11 0.42 0.21
06PB04-13 18 0.94 0.77
06PB04-13 25 0.73 1.5
06PB04-13 28 2.16 2.6
06PB04-13 35 2.5 3.7
06PB05-13 11 0.42 0.21
06PB05-13 18 0.94 0.77
06PB05-13 25 0.85 1.5
06PB05-13 28 2.3 2.6
06PB05-13 35 3 3.7
06PB06-13 11 0.42 0.21
06PB06-13 18 0.94 0.77
06PB06-13 25 1 1.5
06PB06-13 28 2.16 2.6
06PB06-13 35 2.8 3.7
06PB07-13 13 0.53 0.21
06PB07-13 20 1.14 0.77
06PB07-13 27 0.75 1.5
06PB07-13 30 0.95 2.6
06PB07-13 37 2.5 3.7
06PB08-14 13 0.53 0.21
06PB08-14 20 1.14 0.77
06PB08-14 27 0.9 1.5
06PB08-14 30 1.2 2.6
06PB08-14 37 3.5 3.7
06PC07-13 7 0.22 0.21
06PC07-13 14 0.59 0.77
06PC07-13 21 1.24 1.5
06PC07-13 24 0.88 1.5
06PC07-13 31 2 2.6
06PC08-13 13 0.19 0.21
06PC08-13 20 0.19 0.77
06PC08-13 23 0.19 1.5
07PA01-13 11 0.42 0.21
07PA01-13 18 0.94 0.77
07PA01-13 21 1.24 1.5
07PA01-13 28 1.04 2.6
07PA02-14 10 0.37 0.21
07PA02-14 17 0.84 0.77
07PA02-14 24 1.09 1.5
07PA02-14 27 1.09 1.5
07PA02-14 34 1.8 2.6
07PA03-14 10 0.37 0.21
07PA03-14 17 0.84 0.77
07PA03-14 24 1.01 1.5
07PA03-14 27 1.01 1.5
07PA03-14 34 1.9 2.6
07PA04-14 10 0.37 0.21
07PA04-14 17 0.84 0.77
07PA04-14 20 1.14 0.77
07PA04-14 27 1.91 1.5
07PA05-15 9 0.31 0.21
07PA05-15 16 0.74 0.77
07PA05-15 23 0.8 1.5
07PA05-15 26 0.8 1.5
07PA05-15 33 1.5 2.6
07PA06-14 9 0.31 0.21
07PA06-14 16 0.74 0.77
07PA06-14 23 0.9 1.5
07PA06-14 26 0.9 1.5
07PA06-14 33 2.1 2.6
07PA07-14 10 0.37 0.21
07PA07-14 17 0.84 0.77
07PA07-14 20 1.14 0.77
07PA07-14 27 1.12 1.5
07PA08-14 9 0.31 0.21
07PA08-14 16 0.74 0.77
07PA08-14 19 1.04 0.77
07PA08-14 26 1 1.5
07PA09-13 9 0.31 0.21
07PA09-13 16 0.74 0.77
07PA09-13 19 1.04 0.77
07PA09-13 26 1 1.5
07PB01-13 9 0.31 0.21
07PB01-13 16 0.74 0.77
07PB01-13 19 1.04 0.77
07PB01-13 26 1.04 1.5
07PB02-13 7 0.22 0.21
07PB02-13 14 0.59 0.77
07PB02-13 21 0.96 1.5
07PB02-13 24 0.96 1.5
07PB02-13 31 2.06 2.6
07PB03-13 7 0.22 0.21
07PB03-13 14 0.59 0.77
07PB03-13 17 0.84 0.77
07PB03-13 24 0.85 1.5
07PB04-13 9 0.31 0.21
07PB04-13 16 0.74 0.77
07PB04-13 23 1.05 1.5
07PB04-13 26 1.05 1.5
07PB04-13 33 2.3 2.6
07PB05-13 13 0.53 0.21
07PB05-13 16 0.74 0.77
07PB05-13 23 0.8 1.5
07PB06-13 9 0.31 0.21
07PB06-13 16 0.74 0.77
07PB06-13 23 1.1 1.5
07PB06-13 26 1.1 1.5
07PB06-13 33 2.1 2.6
07PB07-13 8 0.26 0.21
07PB07-13 15 0.64 0.77
07PB07-13 22 1.14 1.5
07PB07-13 25 1.14 1.5
07PB07-13 32 2.45 2.6
07PB08-13 13 0.48 0.21
07PB08-13 20 1.14 0.77
07PB08-13 23 0.9 1.5
07PB08-13 30 2.15 2.6
07PB09-13 10 0.37 0.21
07PB09-13 13 0.53 0.21
07PB09-13 20 0.81 0.77
07PB10-13 10 0.37 0.21
07PB10-13 13 0.53 0.21
07PB10-13 20 0.89 0.77
08PA06-15 8 0.26 0.21
08PA06-15 15 0.64 0.77
08PA07-15 8 0.26 0.21
08PA07-15 15 0.64 0.77
08PA08-16 13 0.53 0.21
08PA09-08 13 0.53 0.21
08PA10-08 7 0.22 0.21
08PA10-08 14 0.59 0.77
08PA11-08 7 0.22 0.21
08PA11-08 14 0.59 0.77
08PA12-08 12 0.48 0.21
08PA13-19 13 0.53 0.21
08PA14-19 13 0.53 0.21
08PA15-18 8 0.26 0.21
08PA15-18 11 0.42 0.21
08PA15-18 18 0.94 0.77
08PA16-19 8 0.26 0.21
08PA16-19 11 0.42 0.21
08PA16-19 18 0.94 0.77
08PA17-19 7 0.22 0.21
08PA17-19 10 0.37 0.21
08PA17-19 17 0.84 0.77
08PA18-19 12 0.48 0.21
08PA19-16 12 0.48 0.21
08PA20-18 12 0.48 0.21
08PB02-19 11 0.42 0.21
08PB02-19 14 0.59 0.77
08PB02-19 21 0.85 1.5
08PB03-18 11 0.42 0.21
08PB03-18 14 0.59 0.77
08PB03-18 21 0.76 1.5
08PB04-19 11 0.42 0.21
08PB04-19 14 0.59 0.77
08PB04-19 21 0.79 1.5
08PB05-18 11 0.42 0.21
08PB05-18 14 0.59 0.77
08PB05-18 21 0.82 1.5
08PB06-19 13 0.53 0.21
08PB06-19 16 0.74 0.77
08PB06-19 23 0.98 1.5
08PB07-19 7 0.22 0.21
08PB07-19 14 0.59 0.77
08PB07-19 17 0.84 0.77
08PB07-19 24 0.68 1.5
08PB08-19 11 0.42 0.21
08PB08-19 14 0.59 0.77
08PB08-19 21 0.8 1.5
08PB10-20 13 0.53 0.21
08PB10-20 16 0.74 0.77
08PB10-20 23 0.7 1.5
08PB11-19 9 0.31 0.21
08PB11-19 16 0.74 0.77
08PB11-19 19 1.04 0.77
08PB11-19 26 0.91 1.5
08PB12-20 9 0.31 0.21
08PB12-20 16 0.74 0.77
08PB12-20 19 1.04 0.77
08PB12-20 26 0.98 1.5
08PB13-19 13 0.53 0.21
08PB14-19 13 0.53 0.21
08PB15-21 13 0.53 0.21
08PB15-21 16 0.74 0.77
08PB15-21 23 1.48 1.5
08PB16-21 13 0.53 0.21
08PB16-21 16 0.74 0.77
08PB16-21 23 1.48 1.5
08PC02-22 13 0.53 0.21
08PC03-22 164 0 21.8
08PC03-22 164 0 21.8
08PC03-22 177 0 22.8
08PC03-22 184 0 23.8
08PC03-22 184 0 23.8
08PC03-22 187 0 23.8
08PC03-22 192 0 23.8
08PC03-22 198 0 24.3
08PC03-22 205 0 24.8
08PC03-22 206 0 24.8
08PC03-22 212 0 25.3
08PC03-22 219 0 25.8
08PC03-22 226 0 26.3
08PC03-22 226 0 26.3
08PC03-22 242 0 27.3
08PC03-22 254 0 28.3
08PC03-24 13 0.53 0.21
08PC04-23 13 0.53 0.21
08PC05-23 13 0.53 0.21
08PC06-22 7 0.22 0.21
08PC06-22 14 0.59 0.77
08PC06-22 17 0.84 0.77
08PC06-22 24 0.75 1.5
08PC07-21 9 0 0.21
08PC07-21 13 0.53 0.21
08PC07-21 20 1.14 0.77
08PC07-21 23 0.87 1.5
08PC07-21 30 1.05 2.6
08PC08-22 13 0.53 0.21
08PC08-22 20 1.14 0.77
08PC08-22 23 0.79 1.5
08PC08-22 30 1.1 2.6
08PC10-21 10 0.37 0.21
08PC10-21 17 0.84 0.77
08PC10-21 20 1.14 0.77
08PC10-21 27 0.9 1.5
08PC11-23 12 0.48 0.21
08PC12-23 10 0.37 0.21
08PC12-23 17 0.84 0.77
08PC12-23 20 1.14 0.77
08PC12-23 27 0.88 1.5
08PC13-24 11 0.42 0.21
08PC13-24 14 0.59 0.77
08PC13-24 21 0.8 1.5
08PC14-24 10 0.37 0.21
08PC14-24 17 0.84 0.77
08PC14-24 20 1.14 0.77
08PC14-24 27 0.92 1.5
08PC15-24 10 0.37 0.21
08PC15-24 17 0.84 0.77
08PC15-24 20 1.14 0.77
08PC15-24 27 0.9 1.5
08PC16-22 7 0.22 0.21
08PC16-22 14 0.59 0.77
08PC16-22 17 0.84 0.77
08PC16-22 24 1.03 1.5
08PD02-21 10 0.37 0.21
08PD02-21 17 0.84 0.77
08PD02-21 24 0.98 1.5
08PD02-21 27 1.1 1.5
08PD02-21 34 2 2.6
08PD03-21 10 0.37 0.21
08PD03-21 17 0.84 0.77
08PD03-21 24 0.67 1.5
08PD03-21 27 0.98 1.5
08PD03-21 34 1.66 2.6
08PD04-21 7 0 0.21
08PD04-21 13 0 0.21
08PD04-21 19 0 0.77
08PD04-21 26 1.23 1.5
08PD04-23 13 0.53 0.21
08PD04-23 20 1.14 0.77
08PD04-23 23 0.88 1.5
08PD04-23 30 1.38 2.6
08PD05-22 10 0.37 0.21
08PD05-22 13 0.53 0.21
08PD05-22 20 0.75 0.77
08PD06-21 7 0 0.21
08PD06-21 13 0 0.21
08PD06-21 19 0 0.77
08PD06-21 26 1.51 1.5
08PD06-23 10 0.37 0.21
08PD06-23 13 0.53 0.21
08PD06-23 20 0.78 0.77
08PD07-22 10 0.37 0.21
08PD07-22 13 0.53 0.21
08PD07-22 20 0.81 0.77
08PD08-22 12 0.48 0.21
08PD08-22 19 1.04 0.77
08PD08-22 22 0.68 1.5
08PD08-22 29 1.05 2.6
08PD09-21 12 0 0.21
08PD09-21 18 0 0.77
08PD09-21 25 1.6 1.5
08PD10-22 7 0.22 0.21
08PD10-22 14 0.59 0.77
08PD10-22 21 1.24 1.5
08PD10-22 24 0.8 1.5
08PD10-22 31 1.37 2.6
08PD11-22 7 0.22 0.21
08PD11-22 14 0.59 0.77
08PD11-22 21 1.24 1.5
08PD11-22 24 0.85 1.5
08PD11-22 31 1.02 2.6
08PD12-24 7 0.22 0.21
08PD12-24 14 0.59 0.77
08PD12-24 21 1.24 1.5
08PD12-24 24 0.78 1.5
08PD12-24 31 1.33 2.6
08PD13-23 7 0.22 0.21
08PD13-23 14 0.59 0.77
08PD13-23 21 1.24 1.5
08PD13-23 24 0.9 1.5
08PD13-23 31 1.4 2.6
08PD14-22 7 0 0.21
08PD14-22 13 0 0.21
08PD14-22 19 0 0.77
08PD14-22 26 1.36 1.5
08PD14-24 12 0.48 0.21
08PD15-23 10 0.37 0.21
08PD15-23 17 0.84 0.77
08PD15-23 20 1.14 0.77
08PD15-23 27 1.09 1.5
08PD16-23 10 0.37 0.21
08PD16-23 17 0.84 0.77
08PD16-23 20 1.14 0.77
08PD16-23 27 0.86 1.5
08PE02-21 10 0.37 0.21
08PE02-21 17 0.84 0.77
08PE02-21 20 1.14 0.77
08PE02-21 27 1.34 1.5
08PE03-22 10 0.37 0.21
08PE03-22 17 0.84 0.77
08PE03-22 20 1.14 0.77
08PE03-22 27 1.28 1.5
08PE04-23 10 0.37 0.21
08PE04-23 17 0.84 0.77
08PE04-23 20 1.14 0.77
08PE04-23 27 1.42 1.5
08PE05-23 10 0.37 0.21
08PE05-23 17 0.84 0.77
08PE05-23 20 1.14 0.77
08PE05-23 27 1.44 1.5
08PE06-24 11 0.42 0.21
08PE06-24 18 0.94 0.77
08PE06-24 21 1.24 1.5
08PE06-24 28 1.53 2.6
08PE07-22 11 0.42 0.21
08PE07-22 18 0.94 0.77
08PE07-22 21 0.81 1.5
08PE07-22 28 1.32 2.6
08PE08-24 11 0.42 0.21
08PE08-24 18 0.94 0.77
08PE08-24 21 0.87 1.5
08PE08-24 28 1.32 2.6
08PE10-21 12 0.48 0.21
08PE11-22 11 0.42 0.21
08PE11-22 18 0.94 0.77
08PE11-22 21 0.79 1.5
08PE11-22 28 1.36 2.6
08PE12-23 12 0.48 0.21
08PE13-24 12 0.48 0.21
08PE14-23 10 0.37 0.21
08PE14-23 17 0.84 0.77
08PE14-23 20 1.14 0.77
08PE14-23 27 1.38 1.5
08PE15-23 9 0.26 0.21
08PE15-23 12 0.48 0.21
08PE15-23 19 1.04 0.77
08PE16-23 8 0.26 0.21
08PE16-23 11 0.42 0.21
08PE16-23 18 0.94 0.77
08PF02-22 12 0.48 0.21
08PF02-22 19 1.04 0.77
08PF02-22 22 0.87 1.5
08PF02-22 29 1.56 2.6
08PF03-23 12 0.48 0.21
08PF03-23 19 1.04 0.77
08PF03-23 22 0.83 1.5
08PF03-23 29 1.46 2.6
08PF04-24 9 0.26 0.21
08PF04-24 12 0.48 0.21
08PF04-24 19 1.04 0.77
08PF05-23 12 0.48 0.21
08PF05-23 19 1.04 0.77
08PF05-23 22 1.34 1.5
08PF05-23 29 1.78 2.6
08PF06-25 10 0.37 0.21
08PF06-25 13 0.53 0.21
08PF06-25 20 1.14 0.77
08PF07-23 12 0.48 0.21
08PF07-23 19 1.04 0.77
08PF07-23 22 0.92 1.5
08PF07-23 29 1.96 2.6
08PF09-22 12 0.48 0.21
08PF09-22 19 1.04 0.77
08PF09-22 22 0.63 1.5
08PF09-22 29 1.22 2.6
08PF10-23 12 0.48 0.21
08PF10-23 19 1.04 0.77
08PF10-23 22 0.65 1.5
08PF10-23 29 1.32 2.6
08PF11-24 11 0.42 0.21
08PF11-24 18 0.94 0.77
08PF11-24 21 0.88 1.5
08PF11-24 28 1.8 2.6
08PF12-22 11 0.42 0.21
08PF12-22 18 0.94 0.77
08PF12-22 21 0.9 1.5
08PF12-22 28 1.96 2.6
08PF13-23 11 0.42 0.21
08PF13-23 18 0.94 0.77
08PF13-23 21 0.76 1.5
08PF13-23 28 1.8 2.6
08PF14-24 11 0.42 0.21
08PF14-24 18 0.94 0.77
08PF14-24 21 0.83 1.5
08PF14-24 28 1.52 2.6
09PA01-11 11 0.42 0.21
09PA01-11 18 0.94 0.77
09PA01-11 25 0.68 1.5
09PA01-11 32 2.01 2.6
09PA01-11 39 2.81 3.7
09PA01-11 46 4.27 4.8
09PA01-11 49 4.5 5.9
09PA01-11 56 7.1 7
09PA02-10 10 0.37 0.21
09PA02-10 17 0.84 0.77
09PA02-10 24 0.91 1.5
09PA02-10 31 1.9 2.6
09PA02-10 38 2.87 3.7
09PA02-10 45 3.92 4.8
09PA02-10 48 4 4.8
09PA02-10 55 6.6 5.9
09PA03-10 11 0.42 0.21
09PA03-10 18 0.94 0.77
09PA03-10 25 0.71 1.5
09PA03-10 32 2.15 2.6
09PA03-10 39 2.85 3.7
09PA03-10 46 3.78 4.8
09PA03-10 49 4.1 5.9
09PA03-10 56 7.2 7
09PA04-10 10 0.37 0.21
09PA04-10 17 0.84 0.77
09PA04-10 24 0.82 1.5
09PA04-10 31 2.05 2.6
09PA04-10 38 3.07 3.7
09PA04-10 45 4.03 4.8
09PA04-10 48 4.2 4.8
09PA04-10 55 6.6 5.9
09PA05-10 8 0.26 0.21
09PA05-10 15 0.64 0.77
09PA05-10 22 0.85 1.5
09PA05-10 29 2 2.6
09PA05-10 36 2.68 3.7
09PA05-10 43 3.63 4.8
09PA05-10 46 3.9 4.8
09PA05-10 53 7.2 5.9
09PB01-09 9 0.26 0.21
09PB01-09 16 0.64 0.77
09PB01-09 23 1.34 1.5
09PB01-09 30 1.85 2.6
09PB01-09 37 2.62 3.7
09PB01-09 44 3.68 4.8
09PB01-09 47 3.9 4.8
09PB01-09 54 6 5.9
09PB02-09 9 0.31 0.21
09PB02-09 16 0.74 0.77
09PB03-09 9 0.31 0.21
09PB03-09 16 0.74 0.77
09PB04-10 11 0.42 0.21
09PB05-10 8 0.26 0.21
09PB05-10 15 0.64 0.77
09PB05-10 22 0.98 1.5
09PB05-10 29 1.95 2.6
09PB05-10 36 2.5 3.7
09PB05-10 43 3.53 4.8
09PB05-10 46 3.7 4.8
09PB05-10 53 5.4 5.9
09PB06-09 7 0.22 0.21
09PB06-09 14 0.59 0.77
09PB06-09 21 1.24 1.5
09PB06-09 28 1.79 2.6
09PB06-09 35 2.45 3.7
09PB06-09 42 3.42 4.8
09PB06-09 45 3.6 4.8
09PB06-09 52 4.9 5.9
09PC01-10 12 0.48 0.21
09PC01-10 19 1.04 0.77
09PC01-10 26 0.8 1.5
09PC01-10 33 2 2.6
09PC01-10 40 3.1 3.7
09PC01-10 43 4.2 4.8
09PC01-10 50 5.7 5.9
09PC02-10 8 0.26 0.21
09PC02-10 15 0.64 0.77
09PC02-10 22 0.87 1.5
09PC02-10 29 1.6 2.6
09PC02-10 36 2.6 3.7
09PC02-10 43 3.7 4.8
09PC02-10 46 4.7 4.8
09PC02-10 53 4.9 5.9
09PC03-09 12 0.48 0.21
09PC03-09 19 1.04 0.77
09PC03-09 26 0.7 1.5
09PC03-09 33 2 2.6
09PC03-09 40 2.8 3.7
09PC03-09 43 3.9 4.8
09PC03-09 50 4.8 5.9
09PC04-09 10 0.37 0.21
09PC04-09 14 0 0.77
09PC04-09 17 0.84 0.77
09PC04-09 24 0.7 1.5
09PC04-09 28 1.2 2.6
09PC04-09 31 2 2.6
09PC04-09 37 2.61 3.7
09PC04-09 38 3.1 3.7
09PC04-09 41 4.2 3.7
09PC04-09 42 3.1 4.8
09PC04-09 48 5.4 4.8
09PD01-09 10 0.37 0.21
09PD01-09 13 0.53 0.21
09PD01-09 20 1.14 0.77
09PD02-09 7 0.22 0.21
09PD02-09 10 0.37 0.21
09PD02-09 17 0.84 0.77
09PD03-09 7 0.22 0.21
09PD03-09 10 0.37 0.21
09PD03-09 17 0.84 0.77
09PE01-10 11 0.42 0.21
09PE01-10 18 0.94 0.77
09PE01-10 21 0.78 1.5
09PE01-10 28 1.1 2.6
09PE02-10 12 0.48 0.21
09PE02-10 19 1.04 0.77
09PE02-10 22 0.85 1.5
09PE02-10 29 1.2 2.6
09PE03-09 11 0.42 0.21
09PE03-09 18 0.94 0.77
09PE03-09 21 0.92 1.5
09PE03-09 28 1.1 2.6
09PE04-09 11 0.42 0.21
09PE04-09 18 0.94 0.77
09PE04-09 21 0.75 1.5
09PE04-09 28 1.3 2.6
09PE05-09 11 0.42 0.21
09PE05-09 18 0.94 0.77
09PE05-09 21 0.68 1.5
09PE05-09 28 1.3 2.6
09PF01-11 11 0.42 0.21
09PF02-11 13 0.53 0.21
09PF04-10 13 0.53 0.21
09PF05-10 12 0.48 0.21
09PG01-11 9 0.31 0.21
09PG01-11 16 0.74 0.77
09PG02-11 9 0.31 0.21
09PG02-11 16 0.74 0.77
09PG03-10 9 0.31 0.21
09PG03-10 16 0.74 0.77
09PG04-10 9 0.31 0.21
09PG04-10 16 0.74 0.77
09PG05-10 8 0.26 0.21
09PG05-10 15 0.64 0.77
09PG06-10 7 0.22 0.21
09PG06-10 14 0.59 0.77
10PA01-11 12 0.48 0.21
10PA02-10 12 0.48 0.21
10PA03-10 7 0.22 0.21
10PA03-10 14 0.59 0.77
10PA04-10 7 0.22 0.21
10PA04-10 14 0.59 0.77
10PA05-10 7 0.22 0.21
10PA05-10 14 0.59 0.77
10PA06-10 12 0.48 0.21
10PB01-10 11 0.42 0.21
10PB02-09 10 0.37 0.21
10PB03-09 10 0.37 0.21
10PB04-09 10 0.37 0.21
10PB05-09 10 0.37 0.21
10PB06-09 10 0.37 0.21
10PB07-09 10 0.37 0.21
10PC01-09 8 0.26 0.21
10PC02-09 7 0.22 0.21
10PC03-09 7 0.22 0.21
10PC04-09 7 0.22 0.21
203A01-05 9 0.31 0.21
203B03-05 8 0.26 0.21
203B05-05 9 0 0.21
203B07-05 8 0.26 0.21
203C02-05 9 0.26 0.21
203C05-06 7 0.22 0.21
203C06-06 7 0.22 0.21
205A12-03 14 0 0.77
205A12-03 21 0 1.5
205A12-03 28 1.7 2.6
205A12-03 34 2.65 2.6
205A12-03 35 2.65 3.7
205A12-03 41 4.23 3.7
205A12-03 49 5.4 5.9
205A12-03 49 5.4 5.9
206A06-01 11 0.42 0.21
206A06-01 18 0.94 0.77
206A06-01 25 1.2 1.5
206A06-01 32 2 2.6
206A06-01 35 2 3.7
206A06-01 42 4.1 4.8
206A07-01 11 0.42 0.21
206A07-01 18 0.94 0.77
206A07-01 25 1.3 1.5
206A07-01 32 2.1 2.6
206A07-01 35 2.1 3.7
206A07-01 42 4.3 4.8
206A08-01 11 0.42 0.21
206A08-01 18 0.94 0.77
206A08-01 25 1.1 1.5
206A08-01 32 2.2 2.6
206A08-01 35 2.2 3.7
206A08-01 42 4.3 4.8
206A09-01 9 0.31 0.21
206A09-01 16 0.74 0.77
206A09-01 23 1.1 1.5
206A09-01 30 2 2.6
206A09-01 33 2 2.6
206A09-01 40 3.5 3.7
206A10-01 9 0.31 0.21
206A10-01 16 0.74 0.77
206A10-01 23 1.2 1.5
206A10-01 30 2 2.6
206A10-01 33 2 2.6
206A10-01 40 3.1 3.7
206A11-01 9 0.31 0.21
206A11-01 16 0.74 0.77
206A11-01 23 1 1.5
206A11-01 30 2 2.6
206A11-01 33 2 2.6
206A11-01 40 3 3.7
206A12-01 9 0.31 0.21
206A12-01 16 0.74 0.77
206A12-01 23 1 1.5
206A12-01 30 2.3 2.6
206A12-01 33 2.3 2.6
206A12-01 40 4.2 3.7
206A13-01 7 0.22 0.21
206A13-01 14 0.59 0.77
206A13-01 21 1.25 1.5
206A13-01 28 2.3 2.6
206A13-01 31 2.3 2.6
206A13-01 38 4.2 3.7
206A14-01 7 0.22 0.21
206A14-01 14 0.59 0.77
206A14-01 21 1.24 1.5
206A14-01 28 2.2 2.6
206A14-01 31 2.2 2.6
206A14-01 38 4.5 3.7
206A15-01 7 0.22 0.21
206A15-01 14 0.59 0.77
206A15-01 21 1.24 1.5
206A15-01 28 2.2 2.6
206A15-01 31 2.2 2.6
206A15-01 38 4.4 3.7
206B06-01 13 0.53 0.21
206B06-01 20 1.14 0.77
206B06-01 27 2.1 1.5
206B06-01 34 3.9 2.6
206B06-01 37 3.9 3.7
206B06-01 44 5.2 4.8
206B07-01 7 0.22 0.21
206B07-01 14 0.59 0.77
206B07-01 21 1.24 1.5
206B07-01 28 2.2 2.6
206B07-01 35 4.4 3.7
206B07-01 38 4.4 3.7
206B07-01 45 6 4.8
206B08-01 13 0.53 0.21
206B08-01 20 1.14 0.77
206B08-01 27 1.3 1.5
206B08-01 34 2.4 2.6
206B08-01 37 2.4 3.7
206B08-01 44 5 4.8
206B09-01 7 0.22 0.21
206B09-01 14 0.59 0.77
206B09-01 21 1.24 1.5
206B09-01 28 1.3 2.6
206B09-01 35 3.2 3.7
206B09-01 38 3.2 3.7
206B09-01 45 5 4.8
206B10-01 7 0.22 0.21
206B10-01 14 0.59 0.77
206B10-01 21 1.24 1.5
206B10-01 28 1.2 2.6
206B10-01 35 3 3.7
206B10-01 38 3 3.7
206B10-01 45 5.1 4.8
206B11-01 7 0.22 0.21
206B11-01 14 0.59 0.77
206B11-01 21 1.24 1.5
206B11-01 28 1.2 2.6
206B11-01 35 2.8 3.7
206B11-01 38 2.8 3.7
206B11-01 45 4.3 4.8
206B12-01 7 0.22 0.21
206B12-01 14 0.59 0.77
206B12-01 21 1.24 1.5
206B12-01 28 1.3 2.6
206B12-01 35 3 3.7
206B12-01 38 3 3.7
206B12-01 45 4.5 4.8
206B13-01 13 0.53 0.21
206B13-01 20 1.14 0.77
206B13-01 27 1.3 1.5
206B13-01 34 3 2.6
206B13-01 37 3 3.7
206B13-01 44 4.5 4.8
206B14-01 13 0.53 0.21
206B14-01 20 1.14 0.77
206B14-01 27 1.1 1.5
206B14-01 34 2.8 2.6
206B14-01 37 2.8 3.7
206B14-01 44 4.4 4.8
206B15-01 11 0.42 0.21
206B15-01 18 0.94 0.77
206B15-01 25 1.2 1.5
206B15-01 32 2.7 2.6
206B15-01 35 2.7 3.7
206B15-01 42 5 4.8

I want the data should be like these

01PA01-18 01PA02-18 01PA03-18...206B15-01 Target ABW
Doc ABW Doc ABW Doc ABW Doc ABW
7 0 7 0 7 0 11 0.42 0.21
15 0.59 15 0.59 15 0.59 18 0.77 0.77
22 1.24 22 1.24 22 1.14 25 1.22 1.5
28 0.92 28 0.87 28 0.91 32 2.7 2.6
35 1.82 . . . . . . .
42 2.6 . . . . . . .
49 3.62 . . . . . . .
56 4.64
63 5.54
66 6.24
73 7.25

can u pls help



gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-05-26 : 10:03:21
could you please post a small subset of the problem. Include:

1. CREATE TABLE command for your source table
2. INSERT INTO command to populate your table
3. EXACT expected output from the desired query executed on the newly created and populated table.
Go to Top of Page

kashyap.2000
Starting Member

22 Posts

Posted - 2014-05-26 : 10:50:26
Pivot is the solution , use pivot feature in sql server and your work is done

I love My India.
Go to Top of Page

gbritton
Master Smack Fu Yak Hacker

2780 Posts

Posted - 2014-05-26 : 12:22:33
Pivot may not be so simple. There are multiple columns to aggregate and the column names are dynamic. Here's what I worked up:

1. Create the table

create table rowintocolums (PondCrop varchar(50), DOC int, ABW decimal(8,2), TargetABW decimal(8,2))


2. Populate the table

Insert into rowintocolums values
('01PA02-18',28,0.87,2.6),
('01PA02-18',35,1.8,3.7),
('01PA02-18',42,2.4,4.8),
('01PA02-18',49,3.51,5.9),
('01PA02-18',56,4.6,7),
('01PA02-18',63,5.51,8.1),
('01PA02-18',66,6.53,8.1),
('01PA02-18',73,7.42,9.2),
('01PA03-18',14,0.53,0.77),
('01PA03-18',21,1.14,1.5),
('01PA03-18',27,0.91,1.5),
('01PA03-18',34,1.67,2.6),
('01PA03-18',41,2.2,3.7),
...etc...


3. Setup local variables and template query command


declare @DOC nvarchar(100) = ',max(case when PondCrop = ''{PondCrop}'' then DOC END) as ''{PondCrop}_DOC'' '
declare @ABW nvarchar(100) = ',max(case when PondCrop = ''{PondCrop}'' then ABW END) as ''{PondCrop}_ABW'' '
declare @TargetABW nvarchar(100) = ',max(case when PondCrop = ''{PondCrop}'' then TargetABW END) as ''{PondCrop}_TargetABW'' '
declare @cols nvarchar(max)
declare @sql nvarchar(max) = '
select {cols}
from (select r.*, PondCrop as PondCrop_ABW, PondCrop asPondCrop_TargetAHW
, rn = ROW_NUMBER() over (partition by PondCrop order by (select 1))
from rowintocolums r ) src
group by rn
'


4. Build list of aggregated columns

select @cols = stuff(cols,1,1,'')
from (
select replace(@DOC, '{PondCrop}', PondCrop)
, replace(@ABW, '{PondCrop}', PondCrop)
, replace(@TargetABW, '{PondCrop}', PondCrop)
from rowintocolums
for xml path('')
) x(cols)

select @cols


5. Build final query and execute it

select @sql = replace(@sql, '{cols}', @cols)
select @sql
exec(@sql)


Partial results:


01PA01-18_DOC 01PA01-18_ABW 01PA01-18_TargetABW 01PA01-18_DOC 01PA01-18_ABW 01PA01-18_TargetABW ...
7 0.00 0.21 7 0.00 0.21
15 0.59 0.77 15 0.59 0.77
22 1.24 1.50 22 1.24 1.50
...
Go to Top of Page

GouravSaxena1987
Starting Member

23 Posts

Posted - 2014-05-26 : 12:29:47
I believe your problem can solve by PIVOT but it's not clear that what output you want.

Give some clear sample details of your desired output and sample data.

so we can provide you exact query.

Regards,
Gourav Saxena
Data Warehouse Counsultant
GouravSaxena1987@gmail.com
Go to Top of Page
   

- Advertisement -