USP_BBNC_TABLEENTRY_DATALIST

List of entries defined for a given Blackbaud Internet Solutions code table

Parameters

Parameter	Parameter Type	Mode	Description
@CODETABLEID	int	IN	Input parameter indicating the context ID for the data list.
@INCLUDEINACTIVE	bit	IN	Include inactive?

Definition

Copy



                CREATE PROCEDURE dbo.USP_BBNC_TABLEENTRY_DATALIST

                @CODETABLEID int,
                @INCLUDEINACTIVE bit=1
                with execute as caller

                AS

                set nocount on;

                declare @TABLENAME sysname;
                declare @T table(TABLENAME sysname);
                insert into @T (TABLENAME) exec dbo.USP_BBNC_CODETABLE_GETTABLENAME @CODETABLEID;
                select top 1 @TABLENAME = TABLENAME from @T;

                if @TABLENAME IS NULL return 0;

                exec dbo.USP_BBNC_TABLEENTRY_GETLIST @TABLENAME, @INCLUDEINACTIVE;