title: SQL multiply and round in select statement
body: <p>In part of my select statement, I want to round the value to two decimals. The select has a multiplication where I take one column's value and multiply it by another and divide by 100. I want this value to be returned with only two decimal places but nothing seems to be working right. Here's what I've tried so far:</p>
  
  <pre><code> SELECT
       a.Rate AS 'Rate'
       ,a.LoI AS 'Liability'
   ---------------------------------------------------
   ---- Tried Each Of These Seperately ---------------
   ---------------------------------------------------
  
       CAST(a.Rate * a.LoI / 100, money) AS 'Premium'
  
       ROUND(a.Rate * a.LoI / 100,2) AS 'Premium'
  
       CAST((A.Rate * a.LoI / 100), money) AS 'Premium'
  
       CONVERT(A.Rate * a.LoI / 100, money) AS 'Premium'
  
  FROM tblAspecs a
  </code></pre>
  
  <p>a.Rate is a of data type <code>Decimal(10,2)</code></p>
  
  <p>a.LoI is of data type <code>bigint</code></p>
  
  <p>I'm Using Microsoft SQL Server Management Studio 2010.</p>