Cumulative subtraction

• selpoivre

  Say Hey Kid

  Points: 702

  More actions

  November 17, 2017 at 5:53 am

  #402678

  Hi,
  Col1 
  10
  20
  30
  40

  Need output like this 
  10-0=10
  20-10=10
  30-10=20
  40-20=20

  Output:
  Col1
  10
  10
  20
  20

• Thom A

  SSC Guru

  Points: 99128

  More actions

  November 17, 2017 at 5:56 am

  #1968497

  Duplicate of https://www.sqlservercentral.com/Forums/1908328/Cumulative-subtraction.

  Thom~

  Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
  Larnu.uk