Nadya,

The maximum value for an integer is 2,147,483,647. If you need a bigger number, you could try something like SUM(ytdval) + 0000000000.00 AS ytdval. This should (I think) convert the integer to a normal numeric, and just keep adding 0's until you have enough.

Bill