Count last value + next value and so on 2

[TanTrazz]

Hi All,

Im creating a graph in asp.

What i want to do is count the previous value + next value and so on.

Example:

------------------------------
| ID | Name | Price |
------------------------------
| 1 | cars | 122 |
| 2 | toys | 90 |
| 3 | games | 240 |
------------------------------

What i want is :

the first spot in the graph is 122
the next one is 122+90 = 212
the next one is 212 + 240 = 452
etc.
etc.

Can someone help me with a script or example?

tnQ TanTrazz

 

[TanTrazz]

Or is it possible in the SQL Query?

TanTrazz

 

[guitardave78]

maybe a loop through the values

do while not rs.eof
  firstvalue=rs("price")
  rs.movenext
  total = firstvalue + rs("price")
  response.write(total & "<br />")
loop

}...the bane of my life!

http://www.fuzzyd.co.uk

 

[Sheco]

Try searching the database forums and google on "running total" ... there is more than one way to do it in a stored procedure and some tricks that work with certain databases but not others.

 

[DotNetGnat]

this can be easily done at the sql level...

you are just looking for a running total...

let me search for the code in my repository and get back to you...

-DNG

 

[Sheco]

This one is for Microsoft SQL Server:

http://www.sqljunkies.com/WebLog/amachanic/archive/2006/02/28/18286.aspx

And this is a followup:

http://www.sqljunkies.com/WebLog/amachanic/archive/2006/02/28/18309.aspx

 

[DotNetGnat]

yep...the links Sheco pointed out should get you going...

-DNG

 

[TanTrazz]

Thanks guys

It worked wonderfull.

TanTrazz