UFN_EMAIL_PROCESSCOUNT

Returns the number of instances of the specified global change.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@GLOBALCHANGECATALOGID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_EMAIL_PROCESSCOUNT(@GLOBALCHANGECATALOGID uniqueidentifier)
      returns integer
      with execute as owner
      as begin
        declare @NUMBEROFPROCESSES integer = (select count(*) from dbo.GLOBALCHANGE where GLOBALCHANGECATALOGID = @GLOBALCHANGECATALOGID);

          return @NUMBEROFPROCESSES;
      end