UFN_ALL_UNACKNOWLEDGED_DONATIONS_IN_SPECIFIC_RANGE

Returns all donations within a specific amount range

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@lowerAmount	money	IN
@upperAmount	money	IN

Definition

Copy



CREATE function dbo.UFN_ALL_UNACKNOWLEDGED_DONATIONS_IN_SPECIFIC_RANGE(@lowerAmount money, @upperAmount money)
    returns table
    as return

            select 
          REVENUE.ID 
      from 
          dbo.REVENUE
          inner join REVENUESPLIT on REVENUESPLIT.REVENUEID = REVENUE.ID              
      where 
          revenue.id not in (select REVENUELETTER.REVENUEID from dbo.REVENUELETTER ) and
          (REVENUE.AMOUNT > @lowerAmount and REVENUE.AMOUNT <= @upperAmount)