Lynn Pettis - Wednesday, January 3, 2018 2:00 PM

Maybe this will shed some light on the subject:

DECLARE @testnum DECIMAL(18,2);
SET @testnum = 9.6;
SELECT ROUND(9.6,0);
SELECT ROUND(@testnum,0);
SET @testnum = 99.6;
SELECT ROUND(99.6,0);
SELECT ROUND(@testnum,0);

SET @testnum = 19.6;
SELECT ROUND(19.6,0);
SELECT ROUND(@testnum,0)
SET @testnum = 199.6;
SELECT ROUND(199.6,0);
SELECT ROUND(@testnum,0);

basically, the first two are trying to add an additional digit of precision to the numeric value while the second two aren't.