USP_BBNC_GETTRANSACTIONPROCESSOR_FORBATCHTEMPLATEID

            create procedure dbo.USP_BBNC_GETTRANSACTIONPROCESSOR_FORBATCHTEMPLATEID
            (
                @BATCHTEMPLATEID uniqueidentifier
            )
            as
            set nocount on;

            declare @ASSEMBLYNAME nvarchar(128);
            declare @CLASSNAME nvarchar(128);

            select
                @ASSEMBLYNAME = coalesce(BATCHTYPECATALOG.SPECXML.value
                (
                    'declare namespace bbbatch="bb_appfx_batchtype";
                    /bbbatch:BatchTypeSpec[1]
                    /bbbatch:NetCommunityProcessor[1]
                    /@AssemblyName','nvarchar(255)'
                ), N''),

                @CLASSNAME = coalesce(SPECXML.value
                (
                    'declare namespace bbbatch="bb_appfx_batchtype";
                    /bbbatch:BatchTypeSpec[1]
                    /bbbatch:NetCommunityProcessor[1]
                    /@ClassName','nvarchar(255)'
                ), N'')
            from dbo.BATCHTEMPLATE
            inner join dbo.BATCHTYPECATALOG on BATCHTYPECATALOG.ID = BATCHTEMPLATE.BATCHTYPECATALOGID
            where BATCHTEMPLATE.ID = @BATCHTEMPLATEID;

            if @ASSEMBLYNAME is null
                set @ASSEMBLYNAME = N'';
            if @CLASSNAME is null
                set @CLASSNAME = N'';

            if len(@ASSEMBLYNAME) > 4 and right(upper(@ASSEMBLYNAME),4) = '.DLL'
                set @ASSEMBLYNAME = left(@ASSEMBLYNAME, len(@ASSEMBLYNAME) - 4);

            select
                @ASSEMBLYNAME as [ASSEMBLYNAME],
                @CLASSNAME as [CLASSNAME];