spTransactions_GetUnprocessedDonationsIDsRange

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   procedure dbo.spTransactions_GetUnprocessedDonationsIDsRange(@ClientID int, @StartLetter as nvarchar(1), @EndLetter as nvarchar(1), @Within as bit, @All as bit)
    AS
    begin

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

    end