USP_BBNC_COMMITEVENTREGISTRATIONGUESTUPDATE

Updates a guest's biographical information from an event registration Blackbaud Internet Solutions transaction to the system from a given batch.

Parameters

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

Definition

Copy





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

                declare @SUFFIXCODEID uniqueidentifier = null;

                exec dbo.USP_BBNC_COMMITEVENTREGISTRATIONGUESTUPDATE_1_1
                @ID,
                @FIRSTNAME,
                @MIDDLENAME,
                @KEYNAME,
                @CONSTITUENCYCODEID,
                @CHANGEAGENTID,
                @CHANGEDATE,
                @TITLECODEID,
                @SUFFIXCODEID