title: Rounding difference between decimal and money in .Net and SQL Server
body: <p>Here is the result from linqpad.</p>
  
  <pre><code>decimal d = .035m + .035m + .035m; 
  d.Dump();
  decimal.Round(d,2).Dump();
  0.105
  0.10
  </code></pre>
  
  <p>Here is the result from SMSS.</p>
  
  <pre><code>declare @d money
  set @d = convert(money, .035) + convert(money, .035) + convert(money, .035)
  select @d, round(@d,2)
  (No column name)    (No column name)
  0.105   0.11
  </code></pre>
  
  <p>What gives?</p>