pears.DateRange [iqx]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== pears.DateRange ======
<WRAP center round info>
Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
</WRAP>

===== Original SQL =====
<code sql>
create procedure "pears"."DateRange"( 
  /* Application Maintained Function / Procedure - DO NOT EDIT*/
  in @StartDate date,in @EndDate date ) 
result( "RowNumber" integer,"TheDate" date ) 
on exception resume
begin
  --This proceedure can be joined to directly to provide a date range in a query
  -- dates are inclusive
  declare @LoopCounter integer;
  declare local temporary table "DateRangeTempTable"(
    "TheDate" date null,
    ) on commit delete rows;set @LoopCounter = 1;
  while @StartDate <= @EndDate loop
    insert into "DateRangeTempTable"( "TheDate" ) values( @StartDate ) ;
    set @StartDate = @StartDate+1
  end loop;
  select "Number"(),"TheDate" from "DateRangeTempTable" order by "TheDate" asc
end
go

COMMENT TO PRESERVE FORMAT ON PROCEDURE "pears"."DateRange" IS 
{create procedure DateRange 

/* Application Maintained Function / Procedure - DO NOT EDIT*/

(in @StartDate date,in @EndDate date)
result(RowNumber integer,TheDate date)
on exception resume
begin
  --This proceedure can be joined to directly to provide a date range in a query
  -- dates are inclusive
  declare @LoopCounter integer;
  declare local temporary table DateRangeTempTable(
    TheDate date null
    ) on commit delete rows;set @LoopCounter=1;
  while @StartDate <= @EndDate loop
    insert into DateRangeTempTable( TheDate) values( @StartDate) ;
    set @StartDate=@StartDate+1
  end loop;
  select Number(*),TheDate from DateRangeTempTable order by TheDate asc
end
}
</code>