pears.DateRange

Generated schema reference. Regenerate this page from the SQL unload; keep hand-maintained business notes in the narrative namespace.
Original 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
}