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