spDelete_EmailList_UserDefined
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spDelete_EmailList_UserDefined
@PKID int,
@CurrentUsersID int
AS
DECLARE @ListID int
SET @ListID = (SELECT EmailListID FROM EmailList_UserDefined WHERE [ID] = @PKID)
DELETE [EmailList_UserDefined] WHERE [ID] = @PKID
UPDATE EmailList SET AcquiredRecordCount = (AcquiredRecordCount - 1)
WHERE [ID] = @ListID