Query to find list of dates between two dates

[aravind chandu <avin_friends@xxxxxxxxx>]

Hello guys,

 

can you please help me with the following query

 

I need a query that displays all the dates in between two dates say i give two dates 12/1/2009 and 12/31/2009 The result should be like this

 

12/1/2009

12/2/2009

12/3/2009

 

.

.

.

.

.

12/31/2009

 

Note : Assume that there is no table

 

Thanks,

Aravind.