USP_BBNCUSERMAP_DELETE_BYNAME_WITHCHANGEAGENTID

Deletes the Blackbaud Internet Solutions User mapping.

Parameters

Parameter	Parameter Type	Mode	Description
@NAME	nvarchar(50)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure [dbo].[USP_BBNCUSERMAP_DELETE_BYNAME_WITHCHANGEAGENTID]
            (
                @NAME nvarchar(50),
                @CHANGEAGENTID uniqueidentifier = null

            )
            as
                declare @ID uniqueidentifier

                set nocount on;

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                select @ID=ID from dbo.BBNCUSERMAP where BBNCUSERNAME=@NAME
                if not @ID is null 
                    exec USP_BBNCUSERMAP_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;    

                return 0;