Cumulative sum of SQL Server numbers

Tag:declare   sum   post    Plan    class    float   --   blog   rom   

DECLARE @ Battery table table (date int, day capacity float, planned power yield float, daily average yield float) insert INTO @ battery Gauge Select 1,3.8788,null,3.8024 INSERT INTO @ Battery gauge Select 2,3.8846, null,3.8024 INSERT INTO @ battery gauge Select 3,3.7841, null,3.8024 INSERT INTO @ battery gauge Select 4,3.7946,null,3.8 024 INSERT INTO @ battery Gauge Select 5,3.7672,null,3.8024 INSERT INTO @ battery Gauge Select 6,3.7178,null,3.8024 INSERT INTO @ battery Gauge Select 7    　　, 3.7871,null,3.8024 Select M. Date, SUM (DL. Daily power generation) as charge cumulative from @ Battery table DL INNER JOIN (SELECT * from @ battery gauge) M On (DL. Date <= m. date)--where M. Date <= 7 GROUP by M. Date, M. Day power Generation ORDER by M. Date

Cumulative sum of SQL Server numbers