Here's one way...
--data
declare @StartDate datetime
declare @EndDate datetime
set dateformat mdy
set @StartDate='1/1/06'
set @EndDate='1/4/06'
--numbers table
declare @Numbers table (i int identity(0, 1), j bit)
insert @Numbers select top 10000 null from master.dbo.syscolumns a, master.dbo.syscolumns b
--calculation
select dateadd(d, i, @StartDate) as Date from @Numbers where dateadd(d, i, @StartDate) <= @EndDate
Ryan Randall
Solutions are easy. Understanding the problem, now, that's the hard part.