I am confused and I must be missing something really obvious here. Why does this syntax:

declare @Calc decimal(3,1), @CountDec decimal(3,1), @TotalDec decimal(3,1);

set @CountDec = 145.5;

set @totaldec = 165.5;

set @Calc = (@CountDec/@TotalDec) * 100;

select @Calc;

produce this result:

Server: Msg 8115, Level 16, State 8, Line 2

Arithmetic overflow error converting numeric to data type numeric.

Server: Msg 8115, Level 16, State 8, Line 3

Arithmetic overflow error converting numeric to data type numeric.

(1 row(s) affected)

I have a group of stored procs that worked for a while and have now quit working. What am I missing?

Thanks ,

Ross