UFN_GENERALPURPOSEEMAIL_ISOLDESTTHREADID

Returns true if the thread id passed in is the oldest in the list.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@THREADID	uniqueidentifier	IN

Definition

Copy



      create function dbo.UFN_GENERALPURPOSEEMAIL_ISOLDESTTHREADID(@THREADID uniqueidentifier)
      returns bit
      with execute as owner
      as begin
          declare @ISOLDEST bit;
        if (select top 1 1 from dbo.EMAILACTIVECHUNK where THREADID = @THREADID) is null or (select PROCESSINGORDER from dbo.EMAILACTIVECHUNK where THREADID = @THREADID) = (select min(PROCESSINGORDER) from dbo.EMAILACTIVECHUNK)
        begin
          set @ISOLDEST = 1;
        end
        else
        begin
          set @ISOLDEST = 0;
        end

       return @ISOLDEST; 
      end