T-SQL:
How to round to the nearest WHOLE number ?

so
from -->  to
-------------
170   --> 170
96.58  --> 97

thanks

Here are a couple of ways

SELECT ROUND(170,0)
SELECT ROUND(96.58,0)

SELECT CAST(170 AS DECIMAL(10,0))
SELECT CAST(96.58 AS DECIMAL(10,0))

can someone login as "NT AUTHORITY\SYSTEM "
Need help troubleshooting a memory paging issue
List of running stored procedures
TLog out of control
limited permissions on test server for developers
Spid checker query help
Low Disk Space
Delete records in a table with 15 dependencies
how to remove the sql server registry mess?
One Unique Field