USP_BATCHBBNCPROFILE_GETTRANIDPROCESSORID

Retrieves the Blackbaud Internet Solutions transaction and processor id fields for a profile update batch row.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



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

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