title: Rounding issue in Sql Server 2008 R2 query
body: <p>can anybody help to solve following rounding problem. Thanks in advance</p>
  
  <p>I have number: 3.1050 
  Require Output: 3.10
  but when I use ROUND(3.1050,2) I am getting result 3.11 hence I cant use ROUND over there..
  Following are the some cases which help you solve my question</p>
  
  <p>If value is : 3.1030
  Require output : 3.10
  If value is :3.1050
  Require Output : 3.10
  If value is : 3.1080
  Require output : 3.11</p>