UFN_BBNC_GETCODETABLEMAPID

Returns the integer mapping ID for the specified code table and code table ID for Blackbaud Internet Solutions.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@CODETABLECATALOGID	uniqueidentifier	IN
@ID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_BBNC_GETCODETABLEMAPID
            (
                @CODETABLECATALOGID uniqueidentifier,
                @ID uniqueidentifier
            )
            returns int
            as 
            begin
                return
                (
                    select top 1 ID 
                    from dbo.BBNCCODETABLEIDMAP
                    where CODETABLECATALOGID = @CODETABLECATALOGID
                    and TABLEENTRYID = @ID
                );
            end