spDelete_Email

Parameters

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

Definition

Copy



            CREATE PROC [dbo].[spDelete_Email]
        (
            @PKID int,
            @CurrentUsersID    int
        )
        as

            declare @Guid uniqueidentifier

            begin transaction

                Update [dbo].Email
                    set Deleted = 1
                    where Id = @PKID

                select @Guid =Guid from [dbo].Email where id = @PKID

                exec spAuditThis @CurrentUsersID, 3, @Guid, 15

            commit transaction