title: Sum column up to the current row in SQL?
body: <p>I'm trying to sum a column up to the current row (in SQL Server). How do I do this?</p>
  
  <pre><code>select t1.CounterTime,
         t1.StartTime,
         t1.EndTime,
         isNull(t1.value, 0) as value1,
  
         -- How do I make Total1 the sum of t1.value over all previous rows?
         sum( isNull(t1.value, 0) ) over (partition by t1.CounterTime order by t1.CounterTime) as Total1
  
  from   SomeTable t1
  order by t1.CounterTime
  </code></pre>
  
  <p>But I got the <code>partition by</code> wrong...</p>
  
  <pre><code>╔═══╦═════════════════════════╦═════════════════════════╦═════════════════════════╦════════╦════════╗
  ║   ║      CounterTime        ║        StartTime        ║         EndTime         ║ value1 ║ Total1 ║
  ╠═══╬═════════════════════════╬═════════════════════════╬═════════════════════════╬════════╬════════╣
  ║ 1 ║ 2015-03-17 12:00:00.000 ║ 2015-03-17 00:00:00.000 ║ 2015-03-18 00:00:00.000 ║     0  ║     0  ║
  ║ 2 ║ 2015-03-18 12:00:00.000 ║ 2015-03-18 00:00:00.000 ║ 2015-03-19 00:00:00.000 ║     0  ║     0  ║
  ║ 3 ║ 2015-03-19 12:00:00.000 ║ 2015-03-19 00:00:00.000 ║ 2015-03-20 00:00:00.000 ║   422  ║   422  ║
  ║ 4 ║ 2015-03-20 12:00:00.000 ║ 2015-03-20 00:00:00.000 ║ 2015-03-21 00:00:00.000 ║   989  ║   989  ║
  ║ 5 ║ 2015-03-21 12:00:00.000 ║ 2015-03-21 00:00:00.000 ║ 2015-03-22 00:00:00.000 ║  1162  ║  1162  ║
  ║ 6 ║ 2015-03-22 12:00:00.000 ║ 2015-03-22 00:00:00.000 ║ 2015-03-23 00:00:00.000 ║   524  ║   524  ║
  ╚═══╩═════════════════════════╩═════════════════════════╩═════════════════════════╩════════╩════════╝
  </code></pre>
  
  <p>Should be:</p>
  
  <pre><code>╔════════╗
  ║ Total1 ║
  ╠════════╣
  ║     0  ║
  ║     0  ║
  ║   422  ║
  ║  1411  ║
  ║  2573  ║
  ║  3097  ║
  ╚════════╝
  </code></pre>