USP_BATCHBBNCEVENTREGISTRATION_GETTRANIDPROCESSORID

Retrieves the Blackbaud Internet Solutions transaction and processor id fields for an event registration batch row.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_BATCHBBNCEVENTREGISTRATION_GETTRANIDPROCESSORID
            (
                @ID uniqueidentifier
            )
            as
                set nocount on;

                select top 1
                    BATCHBBNCEVENTREGISTRATION.BBNCTRANID,
                    BATCHBBNCEVENTREGISTRATION.NETCOMMUNITYTRANSACTIONPROCESSORID
                from 
                    dbo.BATCHBBNCEVENTREGISTRATION
                where 
                    BATCHBBNCEVENTREGISTRATION.ID = @ID;