Calculate accumulated with the over ()

Question

Post reply

Calculate accumulated with the over ()

alecio

Grasshopper

Points: 18
More actions
December 6, 2010 at 6:23 am

#231901

How to make a calculation by adding values to the example OVER ... ..
1 - 10 - 10,
2 - 20 - 30.

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 1

alecio (12/6/2010)
How to make a calculation by adding values to the example OVER ... ..
1 - 10 - 10,
2 - 20 - 30.

Can we have a few more sample rows please? As a first-time poster, it's recommended that you read the first link below.

^{“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

alecio Grasshopper Points: 18 More actions · Answer 2

What I need is a sum of values, taking the previous value and adding to the next.

RANK () OVER (PARTITION BY ORDER BY DATE ASC CODIGO_PESSOA, SUM (VALUE)) THE CUMULATIVE.

NO PLACE wanted to rank the accumulated value.

ChrisM@Work SSC Guru Points: 186127 More actions · Answer 3

alecio (12/6/2010)
What I need is a sum of values, taking the previous value and adding to the next.
RANK () OVER (PARTITION BY ORDER BY DATE ASC CODIGO_PESSOA, SUM (VALUE)) THE CUMULATIVE.
NO PLACE wanted to rank the accumulated value.

This would appear to be a Running Totals problem. The articles recommended by stewartc are cutting edge, representing the best of several ways for performing this type of operation. The articles will show you how to write your own SQL to solve your problem. If you require help with this, then you will benefit by providing some sample data.

^{“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