no, you would be trting to sum all columns (1 record) and display all rows individually.
If you want to disply the sum with each row
select (select sum(coalesce(col1,0)) + sum(colesce(col2,0)) from tbltest), *
from tbltest
you can also
select sum(coalesce(col1,0)) + sum(colesce(col2,0)), col1, col2
from tbltest
group by col1, col2
======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.