SUM and ROUND functions - SQLServerCentral.com

... TO 0 DECIMAL PLACES?.. select ROUND SUM( annual_salary as decimal ((8, 0) as'Total' from dbo.

www.sqlservercentral.com