UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMNUMBER

            CREATE function dbo.UFN_GIFTAIDREVENUESPLIT_GETTAXCLAIMNUMBER
      (
      @ID uniqueidentifier
      )
      returns nvarchar(10)
      with execute as caller
      as begin
        declare @TAXCLAIMNUMBER nvarchar(10);

        select @TAXCLAIMNUMBER = TAXCLAIMNUMBER
        from dbo.REVENUESPLITGIFTAID
        where ID in (select ID from dbo.REVENUESPLIT where REVENUEID = @ID);

        return @TAXCLAIMNUMBER;
      end