title: How to truncate then round a number in SQL Server 2008 R2
body: <p>Given these 2 examples, what is the correct syntax to round each example to the whole number. This must be a set operation as the decimal is from a column.</p>
  
  <p>96.001 will be 96 </p>
  
  <p>80.01 will be 81</p>
  
  <p>Thank you,
  Stephen</p>