Cumulative Values

• Meera

  SSCommitted

  Points: 1966

  More actions

  September 29, 2008 at 4:34 am

  Go to Answer

  #198661

  Dear Members,

  kindly help me to sort this out.

  I have 2 Columns like below,

  C1 C2 C3

  10 -- 10

  30 -- 40

  34 -- 74

  66 -- 146

  C3 is my need. how 2 achieve this Cumulative sum of first column in Secont Column. Tht too in Run Time.

  Kindly Help me !!

  Raj.B

• ChrisM@Work

  SSC Guru

  Points: 186127

  More actions

  September 29, 2008 at 4:49 am

  Answer

  #878321

  Hi Raj

  Check out this article http://www.sqlservercentral.com/articles/Advanced+Querying/61716/, it describes in some detail how to do running totals. If you have difficulty with the article or with your specific problem, then repost. As you would expect, running total calculations are order-specific and there are some 'gotchas' - it would help people to solve the problem if you provide more information including the script for your table.

  Cheers

  ChrisM

  ^{“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw}

  For fast, accurate and documented assistance in answering your questions, please read this article.
  Understanding and using APPLY, (I) and (II) Paul White
  Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden