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