UFN_REVENUEUPDATEBATCH_GETCOLLECTIONDESCRIPTION

Returns a list of the solicitors or the constituents associated with recognitions for a certain revenue split ID.

Return

Return Type
nvarchar(1000)

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN
@ISRECOGNITIONS	bit	IN

Definition

Copy



      CREATE function dbo.UFN_REVENUEUPDATEBATCH_GETCOLLECTIONDESCRIPTION
      (
        @REVENUESPLITID uniqueidentifier,
        @ISRECOGNITIONS bit
      )
      returns nvarchar(1000)
      as 
      begin
        declare @RETURN nvarchar(1000)

        if @ISRECOGNITIONS = 1
        begin
          select @RETURN = coalesce(@RETURN + '; ', '') + CONSTITUENT.NAME
          from dbo.UFN_RECOGNITIONCREDIT_DONORCHALLENGE_GETRECOGNITIONS(@REVENUESPLITID) RECOGNITIONS
          inner join dbo.CONSTITUENT on RECOGNITIONS.CONSTITUENTID = CONSTITUENT.ID
        end
        else
        begin
          select @RETURN = coalesce(@RETURN + '; ', '') + CONSTITUENT.NAME
          from dbo.REVENUESOLICITOR
          inner join dbo.CONSTITUENT on REVENUESOLICITOR.CONSTITUENTID = CONSTITUENT.ID
          where REVENUESPLITID = @REVENUESPLITID       
        end

          return @RETURN
      end