spDelete_ClientUsers

        CREATE     PROCEDURE [dbo].[spDelete_ClientUsers]
        (
                @PKID        int,
                @CurrentUsersID    int
        )
        AS

        BEGIN
            declare @Guid uniqueidentifier
            begin transaction
            update ClientUsers set
            Deleted = 1,
            UpdateDate = getutcdate()
            where ID = @PKID

            update NetAccount set Deleted = 1
            where ClientUsersId = @PKID

            select @Guid = Guid from ClientUsers where ID = @PKID
            exec spAuditThis @CurrentUsersID, 3, @Guid, 6
            commit
        END