USP_GENERALPURPOSEEMAIL_UPDATEACTIVETHREAD

      create procedure dbo.USP_GENERALPURPOSEEMAIL_UPDATEACTIVETHREAD
      (
        @PROCESSINGID uniqueidentifier,
        @ADD bit
      )
      as
      begin
        set nocount on;
        if @ADD = 1
        begin
          insert into dbo.EMAILACTIVECHUNK(THREADID) (select @PROCESSINGID where @PROCESSINGID not in (select THREADID from dbo.EMAILACTIVECHUNK));
        end
        else
        begin
          delete from dbo.EMAILACTIVECHUNK where THREADID = @PROCESSINGID;
        end
      end