fnFundRaiserDonationByGiftBackOfficeID

Return

Return Type
table

Parameters

Parameter Parameter Type Mode Description
@GiftBackOfficeID int IN

Definition

Copy

            CREATE function [dbo].[fnFundRaiserDonationByGiftBackOfficeID]
            (
            @GiftBackOfficeID int
            )
            returns table as
            return
            --sterling with changes made to FR Sync we now want the gift regardless of solicitor

            (select ID, DonationTransactionsID, SolicitorID from dbo.FundRaiserDonations where GiftBackOfficeID = @GiftBackOfficeID)-- and SolicitorID = @SolicitorID)