title: How to cast computed column with correct decimal/$ result
body: <p>I have the following computed column in sql server 2008</p>
  
  <pre><code>[Total] AS  CAST ( ((val1/(1000)) * [val2]) AS DECIMAL(18,2))  PERSISTED,
  </code></pre>
  
  <p>When val1 = 862500 and val2 = 8, the computed value = 6896.00</p>
  
  <p>I need it to be decimal/money where (862500/1000) * 8 = 6900.00 (not 6896.00).</p>