spDelete_JobPosts
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PKID | int | IN | |
| @CurrentUsersID | int | IN |
Definition
Copy
CREATE PROCEDURE dbo.spDelete_JobPosts
(
@PKID int ,
@CurrentUsersID int
)
AS
declare @Guid uniqueidentifier
begin transaction
SELECT @Guid = Guid from JobPosts where ID = @PKID
DECLARE @SiteContentID int
SELECT @SiteContentID = SiteContentID
FROM JobBoards b
INNER JOIN JobPosts p on p.JobBoardID = b.[id]
AND p.[id] = @PKID
DELETE FROM Search where SiteContentID = @SiteContentID and SearchInt1 = @PKID
DELETE FROM JobPosts where ID = @PKID
exec spAuditThis @CurrentUsersID, 3, @Guid, 22
commit transaction