SELECT Question: Get each date when I have start und end date

microsoft.public.sqlserver.programming

26 Nov 2006 2:36 PM

Andreas Klemt

Hello,

I have this table:

startdate    enddate       price
11/01/06   11/21/06       45
11/24/06   11/31/06       40

How can I make a SELECT from this table to get each date with a price like
this:

date          price
11/01/06 45
11/02/06 45
11/03/06 45
11/04/06 45
11/05/06 45
11/06/06 45
....

Many thanks for any help!

Regards
Andreas Klemt