Article:		SQL Subqueries
Subject:		accumulate a field
Date:		2006-04-05 21:30:05
From:		paul21_7
Response to: accumulate a field
SELECT date, qty, ( (SELECT qty FROM table b WHERE b.date = (a.date - 1)) + qty ) tqty FROM table a Syntactically its fine ... I made a small assumption on date being the incremental field, so just alter to suit enjoy

Showing messages 1 through 2 of 2.

• accumulate a field
  2006-07-31 07:44:28  kaczmar [Reply | View]
  
  
  it doesn't really work for me. It accumulates a record above only... Is there actually a way to accumulate values in sql without using procedures?
• accumulate a field
  2007-11-15 23:14:04  AdamBerko [Reply | View]
  
  
  Here is how I did it. Seems to work fine
  select ObjectID,StartDate,cscfActiveUsers,
  (
  select sum(cscfActiveUsers)
  from cscf_data b
  where b.StartDate<=a.StartDate
  and a.ObjectID=b.ObjectID
  ) as summ
  from cscf_data a
  order by ObjectID