How would you calculate cumulative sum of a specific column in SQL Server ?

This will help you....

select t1.id, t1.SomeNumt, SUM(t2.SomeNumt) as sum from tableName t1 inner join tableName t2 on t1.id >= t2.idgroup by t1.id, t1.SomeNumt order by t1.id;