Runnig total

• sqlquery-101401

  SSCarpal Tunnel

  Points: 4951

  More actions

  November 6, 2003 at 1:43 am

  #83403

  plz suggest how i can get running total +somecharacters in my select query but for reload it should not be repeated.

  Just like identity

  Thanx

• Greg Larsen

  SSC-Insane

  Points: 20961

  More actions

  November 6, 2003 at 7:42 am

  #481070

  Will something like this work for you.

  create table run(id int identity, num int)

  insert into run (num) values(10)

  insert into run (num) values(20)

  insert into run (num) values(30)

  insert into run (num) values(40)

  insert into run (num) values(50)

  select num, (select sum(num) from run where id <= a.id) "Running Total"

  from run a

  drop table run

  Gregory A. Larsen, DBA

  Contributor to 'The Best of SQLServerCentral.com 2002' book. Get a copy here: http:www.sqlservercentral.com/bestof/purchase.asp

  Need SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

  Gregory A. Larsen, MVP