spDelete_FundRaiserDonations
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spDelete_FundRaiserDonations
(
@PKID int,
@CurrentUsersID int
)
AS
declare @DonationTransactionsID int
select @DonationTransactionsID= DonationTransactionsID
from dbo.FundRaiserDonations
where id=@PKID
begin transaction
delete from FundRaiserDonations where id=@PKID
exec dbo.spTransactions_DeleteDonation @DonationTransactionsID
commit