title: Rounding all Numbers in Database table
body: <p>I need to round all the numbers in a column of a table to 2 decimal places (ie i need 2.109999 to become 2.11)</p>
  
  <p>What is the best way to achieve this? (It only needs to be done as a one off operation)</p>
  
  <p>I am using sql server 2008 R2</p>