spDelete_ClientUserProfile

Parameters

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

Definition

Copy



Create    PROCEDURE dbo.spDelete_ClientUserProfile
(
        @PKID        int,
        @CurrentUsersID    int
)
AS
    declare @Guid uniqueidentifier

        begin transaction
                delete from ClientUserProfile where id=@PKID
/*
        Update ClientUserProfile set Deleted = 1 where ID = @PKID

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

        exec spAuditThis @CurrentUsersID, 3, @Guid, 6
*/
        commit