UFN_BBNC_TRANSACTIONID_ISUNIQUE

      create function dbo.UFN_BBNC_TRANSACTIONID_ISUNIQUE(@BBNCTRANID int)
      returns bit
      with execute as caller
      as begin
            declare @DUPLICATECOUNT int = 0;

          select
            @DUPLICATECOUNT = count(ID)
          from
            dbo.BBNCTRANSACTIONDOWNLOADEXCEPTION
          where
            BBNCTRANID = @BBNCTRANID

          if (@DUPLICATECOUNT <= 1)
            return 1;

            return 0;
      end