Rounding Result To Nearest Integer

[PrgrmsAll]

I need to have the following SQL round the result to the nearest integer:

SELECT v_MASTER_FACTOR.FACTOR * CAST(COUNT(Parts.PartsID) AS decimal(9)) AS intResult

Currently it is returning 0.9999999999, I need this to show 1, etc.

Thanks in advance.

 

[SQLDenis]

use ceiling

select ceiling(0.9999999999)

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[Juice05]

Round(Value,1,0)

 

[SQLDenis]

scrap that
ceiling will always 'round' up and floor will always 'round' down

use round instead like suggested by Juice05

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[earthandfire]

Or, of course you could use:

select parsename(Value + 0.5, 2)



Hope this helps

 

[PrgrmsAll]

Thanks to all for your great suggestions.