title: SQL Server round after division
body: <p>In a stored procedure I have an expression like</p>
  
  <pre><code>select @some_val_in_percents = (@total_val / 100) * @some_val
  </code></pre>
  
  <p>If I use the <code>Round</code> function like this:</p>
  
  <pre><code>select @some_val_in_percents = Round((@total_val / 100) * @some_val, 0)
  </code></pre>
  
  <p>will the result be rounded when the whole expression is calculated or will <code>(@total_val / 100)</code> be rounded and than multiplied by <code>@some_val</code>?</p>