title: Calculations VAT++ in SQL Server 2008
body: <p>I can't post the whole procedure here because it would be to confusing. What I am trying to do is calculating VAT. To do that I need to multiply <code>Share</code> with 0,25. </p>
  
  <pre><code> select.....
      (SALES_PRICE * 0.8) as Revenue, 
      (SALES_PRICE * 0.8 * 1-u.discount) as Share,
      (SALES_PRICE * 0.8 * 1-u.discount) * 0.25 as VAT, 
      (SALES_PRICE * 0.8 * 1-u.discount) + (isa.SALES_PRICE * 0.8 * (1-u.discount) * (0.25)) as Total
  </code></pre>
  
  <p>Edit: Got some great help and ended up with correct calculations and formatting. 
  <strong>Here is the result:</strong></p>
  
  <pre><code>       CONVERT(DECIMAL(30, 2), ( sales_price * 0.8 )) 
         AS Revenue, 
         CONVERT(DECIMAL(30, 2), ( sales_price * 0.8 * 1 - u.discount )) 
         AS Share, 
         CONVERT(DECIMAL(30, 2), ( sales_price * 0.8 * 1 - u.discount ) * 0.25) 
         AS VAT, 
         CONVERT(DECIMAL(30, 2), ( sales_price * 0.8 * 1 - u.discount ) * 1.25) 
         AS Total
  </code></pre>