title: How to get a running total in SQL without using cursor?
body: <p>I have a problem mentioned below</p>
  
  <pre><code>wkSales    ytdSale      
  2839        15513      
  2925        18202      
  2705        20693      
  2643        22499      
  2515        24688      
  1999        26128      
  </code></pre>
  
  <p>I want to add wkSales of second row to ytdSales of first row and show their addition in second Row of ytdSale Column how can i achieve this in sql server 2008 please help me </p>