UFN_PLEDGE_GETPASTDUEAMOUNT_BYDATERANGE

CREATE function dbo.UFN_PLEDGE_GETPASTDUEAMOUNT_BYDATERANGE
(
  @PLEDGEID uniqueidentifier,
  @STARTDATE datetime,
  @ENDDATE datetime
) 
returns money
with execute as caller
as
begin
  declare @RESULT money;

  select @RESULT = 
    isnull(
      (select
         sum ( dbo.UFN_INSTALLMENT_GETINSTALLMENTBALANCE(INSTALLMENT.ID))
       from dbo.INSTALLMENT
       where INSTALLMENT.REVENUEID = @PLEDGEID 
       --The "GETLATESTTIME" date function has been inlined here for performance (the part with "dateadd(ms, -003...")...

       and dateadd(ms, -003, dateadd(d, 1, cast(cast(INSTALLMENT.DATE as date) as datetime))) >= @STARTDATE
       and dateadd(ms, -003, dateadd(d, 1, cast(cast(INSTALLMENT.DATE as date) as datetime))) < @ENDDATE),
      0);

  return @RESULT;
end