/>So if the date range is '2001-01-15' to '2003-04-01' then it would
>approx 800 rows with dates between these 2 ranges. I can't seem to figure
>out how to do it without writing a program./
See Dates/'Make a calendar table at
> This one has me puzzled. All I need to do is create a table of dates,
> one date per row, from a starting to ending date.
> So if the date range is '2001-01-15' to '2003-04-01' then it would
> generate approx 800 rows with dates between these 2 ranges. I can't
> seem to figure out how to do it without writing a program. Is there a
> way to generate these rows using just one sql statement? Or am I
> relegated to writing a program to generate these dates?
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.405 / Virus Database: 268.10.8/415 - Release Date: 8/9/2006