USP_BBNC_COMMITDONORINFORMATIONBIOUPDATE

Updates a constituent's biographical information from a Blackbaud Internet Solutions transaction with donor information to the system from a given batch.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@TITLECODEID	uniqueidentifier	IN
@FIRSTNAME	nvarchar(50)	IN
@KEYNAME	nvarchar(100)	IN
@CONSTITUENCYCODEID	uniqueidentifier	IN
@XMLITEMS	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            CREATE procedure dbo.USP_BBNC_COMMITDONORINFORMATIONBIOUPDATE
            (
                @ID uniqueidentifier = null,
                @TITLECODEID uniqueidentifier = null,
                @FIRSTNAME nvarchar(50) = '',
                @KEYNAME nvarchar(100),
                @CONSTITUENCYCODEID uniqueidentifier = null,
                @XMLITEMS xml = null,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
                set nocount on;

                declare @MIDDLENAME nvarchar(50) = '';

                exec USP_BBNC_COMMITDONORINFORMATIONBIOUPDATE_1_1 
                                                            @ID,
                                                            @TITLECODEID ,
                                                            @FIRSTNAME ,
                                                            @KEYNAME ,
                                                            @CONSTITUENCYCODEID ,
                                                            @XMLITEMS ,
                                                            @CHANGEAGENTID ,
                                                            @CHANGEDATE,
                                                            @MIDDLENAME

                return 0;