Re: [SQL] seleting all dates between two dates

2001-06-06 Thread Josh Berkus
Jeff, > I am interested in a query where I can select all dates between two > dates. I > figure I can build a table of all valid dates with a resonable range > and > then select from that table, but I would like to use the power of sql > to get > the work done without building a date table. Any i

[SQL] seleting all dates between two dates

2001-06-06 Thread Jeff Barrett
I am interested in a query where I can select all dates between two dates. I figure I can build a table of all valid dates with a resonable range and then select from that table, but I would like to use the power of sql to get the work done without building a date table. Any ideas? For example: I