USP_BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGE_DELETEBYBATCHID
Auto-generated procedure to handle error/rejection/exception messages for the BATCHBBNCMEMBERSHIP batch message table
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BATCHID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 3/19/2013 1:29:14 AM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=3.0.504.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE PROCEDURE dbo.USP_BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGE_DELETEBYBATCHID
(
@BATCHID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as
set nocount on;
declare @contextCache varbinary(128);
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @contextCache = CONTEXT_INFO();
set CONTEXT_INFO @CHANGEAGENTID;
delete from dbo.BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGE where exists (select BATCHBBNCMEMBERSHIP.ID from dbo.BATCHBBNCMEMBERSHIP where BATCHBBNCMEMBERSHIP.ID = BATCHBBNCMEMBERSHIPBATCHSYSTEMMESSAGE.ID and BATCHID = @BATCHID);
if not @contextCache is null
set CONTEXT_INFO @contextCache;
return 0;