Running Sales Sum

• mssql_rules

  SSCrazy

  Points: 2783

  More actions

  January 19, 2004 at 4:09 pm

  #107706

  I have a table

  SaleDate 1 2 3 4  5

  SalesAmount 5 6 7 8  10 

  I need a report on the running sales sum for the previous 2 days, ie.,

  for each sale date show the sum of sales for the previous  2 day period

  (3 including the current one)

  like:

  SaleDate 1 2 3 4 5

  3DaySum  5 11 18 21 25

  I have n't had much luck without using a cursor. Any work arounds?

   

• mssql_rules

  SSCrazy

  Points: 2783

  More actions

  January 19, 2004 at 4:17 pm

  #490753

  Never mind,

  I got it.

   

  select s1.saledate, sum (s2.amount)

  from sales s1, sales  s2

  where s2.saledate between s1.saledate - 2 and s1.saledate

  group by s1.saledate