UFN_GENERATE_DATES

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@STARTDATE	date	IN
@ENDDATE	date	IN

Definition

Copy


create function BBDW.[UFN_GENERATE_DATES](@STARTDATE date,@ENDDATE date)
returns @T table (DATEVALUE date)
as
begin

  declare @CURRENT date;

  set @CURRENT = @STARTDATE;

  while @CURRENT <= @ENDDATE
  begin
    insert into @T (DATEVALUE) values (@CURRENT);
    set @CURRENT = DATEADD(day,1,@CURRENT);
  end

  return ;
end