I have calculated a percentage in TSQL, which the output looks like this

Col1

0.0554542

0.058371

0.121307

0.049364

0.109037

0.165925

This is then converted to a percentage in SSRS 2005, which looks like this

5.5%

5.8%

12.1%

4.9%

10.9%

16.6%

How do i within TSQL use the result from the percentage calculation to work out the percentage... so for example, I would update Col2 using Col1, so the results looks like this..

5.5

5.8

12.1

4.9

10.9

16.6

**View Complete Post**

## Rounding a number based upon it's midpoint

I need to round down, or round up a floaitng point number to it's closest integer value.

So for example 3.49999 is closer to 3 so it would round down to the integer 3.

3.5002 is closer to 4 so this would round up to the integer 4.

I do not need to be concerned negative numbers. Can someone show me how to do this?

Here are more examples to make clear what I am talking about