On May 5, 8:37 am, supagroova <supagro...@gmail.com> wrote:
> 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.

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.