title: Result in single row
body: <p>I want to sum of each parameter as column adding in my parameter table 
  table structure is of two columns ParamaterId and ResultValue
  Value of table is</p>
  
  <pre><code>ParameterId ResultValue
  2D/Ao Root Diam 0.03154840000000
  AVA (VTI)   0.00016937690000
  AVA (VTI)   0.00016937690000
  2D/Ao Root Diam 0.03473202000000
  AVA (VTI)   0.00006636187000
  AVA (VTI)   0.00006755497000
  </code></pre>
  
  <p>I want to show ParameterId as Column Heading and Sum of ResultValue </p>
  
  <pre><code>AVA (VTI)             2D/Ao Root Diam
  Sum(ResultValue)       Sum(ResultValue)
  </code></pre>
  
  <p>Below query producing correct resutl but the result is not is a single row, I need output should be in single row</p>
  
  <pre><code>AVA (VTI)          2D/Ao Root Diam
  .573844582491253138     0
  0                     18.5821659893339723
  </code></pre>
  
  <p></p>
  
  <pre><code>select 
      sum (case when ParameterId = 'AVA (VTI)' then (ResultValue) else 0 end) as 'AVA (VTI)',
      sum(case when ParameterId = '2D/Ao Root Diam' then (ResultValue) else 0 end) as '2D/Ao Root Diam'
     from DBCREATORS.Parameter as P
  where ParameterId 
  in ('AVA (VTI)', '2D/Ao Root Diam')
     group by ParameterId
  </code></pre>
  
  <p>Desired Result should be</p>
  
  <pre><code>AVA (VTI)              2D/Ao Root Diam
  .573844582491253138    18.5821659893339723 
  </code></pre>
  
  <p>Please help</p>
  
  <p>Thanks,</p>