Home Forums SQL Server 2008 T-SQL (SS2K8) Counting field values per day between specific date ranges RE: Counting field values per day between specific date ranges

  • Just one item of consideration that I wanted to throw out there. The bookings can change from day to day, since from a business perspective I imagine each booking can be canceled. It is not a bad idea to take daily snapshots as not only can you gather average bookings looking ahead, but average number of cancels as well.

    Are you reporting on this data directly into a report? This is a candidate for a fact table for a data cube BTW.

    ----------------------------------------------------