title: Query to list data based comparison of 2 x numeric values
body: <p>I have a SQL Server 2008 R2 query:</p>
  
  <pre><code>select 
      comp_companyid, balt, clim 
  from 
      vCompanyOverCL
  </code></pre>
  
  <p>which returns multiple rows which each row as follows.</p>
  
  <pre><code>comp_companyid  balt  clim
  --------------  ----  ----
            1112  1100  1000
  </code></pre>
  
  <p>I need to add a where clause that only returns data where the balt is 20% greater than clim (these are both numeric fields)</p>
  
  <p>In the above example it wouldn't be returned as its only 10%</p>
  
  <p>Any help would be appreciated.</p>
  
  <p>Mim</p>