fnTransactions_GetUnprocessedDonationsCountRange

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode
@ClientID	int	IN
@StartLetter	nvarchar(1)	IN
@EndLetter	nvarchar(1)	IN
@Within	bit	IN
@All	bit	IN

Definition

Copy



create function dbo.fnTransactions_GetUnprocessedDonationsCountRange (@ClientID int, @StartLetter as nvarchar(1), @EndLetter as nvarchar(1), @Within as bit, @All as bit)
    returns integer
    as
    begin

    declare @Count integer

    if (@all=1)
        begin
            select @Count=count(*) from fnTransactions_GetUnprocessedGiftsForClient(@ClientID)
        end
    else
        begin
            select @Count=count(*) from dbo.fnTransactions_GetUnprocessedGiftsForClientRange(@ClientID, @StartLetter, @EndLetter, @Within)
        end
    return @Count
    end