spGetFundraiserChangeBuckets

Parameters

Parameter Parameter Type Mode Description
@FundraiserID int IN

Definition

Copy


            CREATE PROCEDURE dbo.spGetFundraiserChangeBuckets
            (
                @FundraiserID int
            )

            AS

            BEGIN
                select frd.ID, frd.DonationTransactionsID, dt.XMLObjectData, dt.AddedByUserID
                from dbo.FundRaiserDonations frd
                inner join dbo.DonationTransactions dt on dt.DonationTransactionsID = frd.DonationTransactionsID
                inner join dbo.FundRaiserSolicitors frs on frs.ID = frd.SolicitorID
                where frs.RootFundRaiserID = @FundRaiserID and frd.IsChangeBucket = 1
            END