|
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
Navigation:
[Reply to this message]
|