USP_PROSPECTRESEARCHREQUESTCANCELCODE_DELETEENTRY
Used to delete a table entry in the "Prospect Research Request Cancel Code" code table.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The ID of the table entry being deleted. |
| @CHANGEAGENTID | uniqueidentifier | IN | The ID of the change agent deleting the table entry. |
Definition
Copy
/*
Generated by Blackbaud AppFx Platform
Date: 1/27/2010 7:23:43 PM
Assembly Version: Blackbaud.AppFx.Platform.SqlClr, Version=2.5.465.0, Culture=neutral, PublicKeyToken=null
Copyright Blackbaud
*/
CREATE procedure dbo.USP_PROSPECTRESEARCHREQUESTCANCELCODE_DELETEENTRY
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = NULL
)
as
SET NOCOUNT ON;
declare @s int
select @s = SEQUENCE
from dbo.PROSPECTRESEARCHREQUESTCANCELCODE
where ID = @ID
declare @r int
exec @r= dbo.USP_PROSPECTRESEARCHREQUESTCANCELCODE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
if @r <> 0 return @r;
update dbo.PROSPECTRESEARCHREQUESTCANCELCODE
set SEQUENCE = SEQUENCE - 1,
CHANGEDBYID=@CHANGEAGENTID,
DATECHANGED=GETDATE()
where SEQUENCE > @s;
return 0;