title: Rounding up and down of numbers with specific decimal points
body: <p>I am using SQL Server 2008 R2 and I want to find rounding up and down values with specific decimal points as shown as below: </p>
  
  <p><strong>For Example:</strong></p>
  
  <ol>
  <li><p>If my Value is <strong>1.27845</strong> and I want the answer with 2 decimal places then my answer should be </p>
  
  <ol>
  <li><strong>Rounding UP: 1.28</strong></li>
  <li><strong>Rounding Down: 1.27</strong></li>
  </ol></li>
  <li><p>If my Value is <strong>33.33333</strong> and I want the answer with 2 decimal places then my answer should be </p>
  
  <ol>
  <li><strong>Rounding UP: 33.34</strong> </li>
  <li><strong>Rounding Down: 33.33</strong></li>
  </ol></li>
  <li><p>If my Value is <strong>1.27845</strong> and I want the answer with 3 decimal places then my answer should be </p>
  
  <ol>
  <li><strong>Rounding UP: 1.279</strong></li>
  <li><strong>Rounding Down: 1.278</strong></li>
  </ol></li>
  <li><p>If my Value is <strong>33.33333</strong> and I want the answer with 3 decimal places then my answer should be </p>
  
  <ol>
  <li><strong>Rounding UP: 33.334</strong></li>
  <li><strong>Rounding Down: 33.333</strong></li>
  </ol></li>
  </ol>
  
  <p>I want common solution for all cases. 
  Thanks...</p>