IF (EXISTS(Select * from sys.sysprocedure where LCase(proc_name) = LCase('GetBookFactorRazpredelenie')))
THEN Drop procedure GetBookFactorRazpredelenie
END IF

GO

create function
DBA.GetBookFactorRazpredelenie(in @BookNo integer,in @StartDate date,in @EndDate date)
returns numeric(12,2)
begin
  declare @TotalDays integer;
  declare @TotalStaying integer;
  declare @Factor numeric(12,2);
  set @TotalDays=datediff(day,@StartDate,@EndDate)+1;
  if @TotalDays <= 0 then
    return 0
  end if;
  set @Factor=0;
  set @TotalStaying=GetNumLodgingsInPeriod(@BookNo,@StartDate,@EndDate);
  if(@TotalStaying > 0) then
    set @Factor=convert(numeric(12,2),@TotalStaying)/@TotalDays
  end if;
  return @Factor
end
//[2009_02_27 MON] Nixon - created