SQL to return date range

[qball]

I thought I knew an easy way to do this, but perhaps in the past used stored proc, or other object to accomplish...

How does one display all days from a given date range? As in:

tbl1
----
id
date

for example purposes, tbl1 is empty, 0 rows.

SELECT id FROM tbl1 WHERE date BETWEEN
"2003-2-01" and "2003-2-28";

And get 28 rows, with id = NULL.

OR if tbl1, has rows in date range, return that id, rest NULLs.

Seems silly to create:
tbl2
----
id = NULL
date = all dates for a year???

Then outer join to tbl1...

[vass0922]

Hmm not sure if it would be possible with out a cursor...

Cursor would be fairly easy with a loop, but not quite as simple as a single statement.


Hmmm.. you used double quotes for those dates.. this isn't access is it?!

If so disregard the cursor, you're probably going to end up writing VBA or something

[Creosote]

I guess I'd say stored proc. #Temporary Table. Loop to insert dates in temp table. Use left join. Show all records from temp table that you inserted from date range and matching records from table with data.

[qball]

vass0922,

not access, any real DBMS!

as stated, stored proc, with cursor to find data that does exist, fill in empty dates, created from date range request....

or 'object', access has these, as most client/server apps, also.