USP_BBNC_GETBATCHBBNCTRANIDS_1_3

Retrieves a list of all Blackbaud Internet Solutions transaction ids in batches for the batch template ID specified for BBIS whose statuses are open, waiting for approval, or approved.

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHTEMPLATEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure [dbo].[USP_BBNC_GETBATCHBBNCTRANIDS_1_3](@BATCHTEMPLATEID uniqueidentifier)
            with execute as owner
            as

            begin
                declare @TABLENAME nvarchar(128);
                declare @SQL nvarchar(300);

                select top 1 @TABLENAME = BATCHTYPECATALOG.BASETABLENAME
          from dbo.BATCHTEMPLATE 
                    inner join dbo.BATCHTYPECATALOG on BATCHTEMPLATE.BATCHTYPECATALOGID = BATCHTYPECATALOG.ID
                    where BATCHTEMPLATE.ID = @BATCHTEMPLATEID
                    order by BATCHTEMPLATE.DATEADDED;


if not @TABLENAME is null 
    begin
        if @TABLENAME = 'BATCHCONSTITUENTUPDATE'
            begin
                set @SQL = N'select BBNCTRANID from dbo.' + @TABLENAME + N' inner join dbo.BATCH on ' + @TABLENAME + N'.BATCHID = BATCH.ID ';
                set @SQL = @SQL + N' left join ' + @TABLENAME + N'BBNCINFO on ' + @TABLENAME + N'.ID = ' + @TABLENAME + N'BBNCINFO.' + @TABLENAME + 'ID';
                set @SQL = @SQL + N' where BATCH.STATUSCODE = 0';
            end
        else
            begin
                set @SQL = N'select BBNCTRANID from dbo.' + @TABLENAME + N' inner join dbo.BATCH on ' + @TABLENAME + N'.BATCHID = BATCH.ID ';
                set @SQL = @SQL + N' where BATCH.STATUSCODE = 0';
            end
    exec sp_executesql @SQL;
    end
else
    select 0 as BBNCTRANID from dbo.BATCH where ID = '00000000-0000-0000-0000-000000000000'
            end