I have tried various approaches to doing this but nothing seems to work! I need to add up the values (all tinyint) in a row. Please help! thanks...
My guess is that one or more rows is NULL.
Try something like this:
select sum(isnull(mytimycolumn,0)) from mytable
