spDelete_EventItems

Parameters

Parameter Parameter Type Mode Description
@PKID int IN
@CurrentUsersID int IN

Definition

Copy


    CREATE   PROCEDURE dbo.spDelete_EventItems
    (
            @PKID        int,
            @CurrentUsersID    int
    )
    AS
        declare @Guid uniqueidentifier

            begin transaction

    /*        Update Clients set Deleted = 1 where ID = @PKID

            select @Guid = Guid from Clients where ID = @PKID

            exec spAuditThis @CurrentUsersID, 3, @Guid, 16 */
            DELETE FROM EventItems WHERE ID=@PKID

        commit