UFN_BBNC_NUMBEROFACTIVEPROCESSORS

Returns the number of active processors for an assembly name/class name pair.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@ASSEMBLYNAME	nvarchar(255)	IN
@CLASSNAME	nvarchar(255)	IN

Definition

Copy



            create function dbo.UFN_BBNC_NUMBEROFACTIVEPROCESSORS
            (
                @ASSEMBLYNAME nvarchar(255),
                @CLASSNAME nvarchar(255)
            )
            returns int
            as
            begin
                declare @R int;

                select @R = count(ID) from dbo.NETCOMMUNITYTRANSACTIONPROCESSOR where ASSEMBLYNAME = @ASSEMBLYNAME and CLASSNAME = @CLASSNAME and ISACTIVEPROCESSOR = 1;

                return coalesce(@R, 0);
            end