Hi,

In one of the queries, we get:

01/01/2003 10
01/03/2003 1
...

We want to show
01/01/2003 10
01/02/2003 0
01/03/2003 0
01/04/2003 1
...

Is there a way to generate all the dates, say, for one year?

Thanks.