Thunderstone Support Forums

I have a table that has a column that is smallint. When I do a sum on that column it comes out to 25,770 when it should be closer to 7,361,830. Whats the deal?

It's summing in the type of the column, which will overflow. Try

sum(convert(col, 'long'));

smallint will only hold 16 bit values so it rolls over when summing. convert to a data type large enough for the sum.
sum(convert(Field,'int'))