Home Forums SQL Server 7,2000 T-SQL Current Order Date and Average Count of Orders for Three Prior Days RE: Current Order Date and Average Count of Orders for Three Prior Days

  • It kind of seems to me David is looking for a rolling three day average. If today is the third day of the month, say 10/3, then he needs the average for 10/1+10/2+10/3. Tomorrow will be the fourth day of the month so he will need the average for 10/2+10/3+10/4, and so on.

    Greg
    _________________________________________________________________________________________________
    The glass is at one half capacity: nothing more, nothing less.