USP_BBNC_TRANSACTION_MARKUNSUCCESSFULDOWNLOAD
Adds a Blackbaud Internet Solutions transactions to the the list of unsuccessful downloads.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BBNCID | int | IN |
Definition
Copy
CREATE procedure dbo.USP_BBNC_TRANSACTION_MARKUNSUCCESSFULDOWNLOAD
(
@BBNCID int
)
as
set nocount on;
delete from dbo.BBNCDOWNLOADEDTRANSACTION
where
ID = @BBNCID;
if not exists
(
select
ID
from
dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
where
ID = @BBNCID
)
insert into dbo.BBNCUNSUCCESSFULDOWNLOADTRANSACTION
(
ID
)
values
(
@BBNCID
);
return 0;