title: Rounding Up in SQL
body: <p>I would like to get the value of 50/60 as 1.
  However all the following returns 0</p>
  <pre><code>DECLARE @value decimal(10,2)
  SET @value = 50/60
  Select @value
  SELECT ROUND(@value, 2) RoundNumber
  SELECT CEILING(@value) CeilingNumber
  SELECT FLOOR(@value) FloorNumber
  
  </code></pre>
  <p>Can you please advice?</p>