Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Running date query

    I want to create a query which sums up the number of times the user usages
    my service per day. I have a table which logs every time the user uses the service, but i want the query to display dates when there was no usage as "0", meanning that I need query to run on all of the dates in a set interval, even those who does not appear in the table.
    How do I do it?

    Thanx ahead

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    see Selecting all months even if they're missing (site registration may be required, but it's free) | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts