Hi all,

I have what I think is a rather a curly question:

Is there a way to select all days in a month (or week, year, any
period) without having matching rows in a table?

So in essence, can I create a query that returns all the days in a
period without looking up a table?

To give some background, I am trying to output records for a graphing/
reporting tool and I only have non-zero records in my table.

Any insights, suggestions are warmly welcomed!

Thanks.

On May 5, 8:37 am, supagroova <supagro... (AT) gmail (DOT) com> wrote:
Not that I know of other than creating a temporary table then filling
it with values. It isn't uncommon to have a "calendar" table that
just includes every date within some reasonable range. You'd be
surprised at how much easier that makes some things -- then it's just
an outer join from that table and you have all your zeros.

On May 5, 3:00*pm, ZeldorBlat <zeldorb... (AT) gmail (DOT) com> wrote:
I absolutely agree with Zaldor. I usually have a `sequence` table
running from 1..366 for all days in a year. Very helpful indeed

Thanks guys. That's a big help!