Posted by PromisedOyster on 10/08/05 08:11

Is there a way that I can get a resultset that contains unique dates in
a given date range without the need to have a temporary table and a
cursor?

perhaps something like:

declare @start_date as datetime
declare @end_date as datetime
set @start_date as '1/1/2005'
set @end_date as '1/1/2006'
select fn_getuniquedate(@start_date, @end_date)


1/1/2005
1/2/2005
1/3/2005
...
12/31/2005

[Back to original message]