UFN_REVENUEBATCH_GETCOLLECTIONDESCRIPTION_3

Return

Return Type
nvarchar(1000)

Parameters

Parameter	Parameter Type	Mode
@TYPECODE	tinyint	IN
@DESIGNATIONID	uniqueidentifier	IN
@BATCHREVENUEID	uniqueidentifier	IN
@ISRECOGNITIONS	bit	IN
@DECLINESGIFTAID	bit	IN
@SPONSORSHIPID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_REVENUEBATCH_GETCOLLECTIONDESCRIPTION_3
     (
        @TYPECODE tinyint,
        @DESIGNATIONID uniqueidentifier,
        @BATCHREVENUEID uniqueidentifier,
        @ISRECOGNITIONS bit,
        @DECLINESGIFTAID bit,
      @SPONSORSHIPID uniqueidentifier
      )
      returns nvarchar(1000)
      as 
      begin
        declare @RETURN nvarchar(1000)

        if @ISRECOGNITIONS = 1
        begin
          select @RETURN = coalesce(@RETURN + '; ', '') + CONSTITUENT.NAME
          from dbo.BATCHREVENUERECOGNITION
          inner join dbo.CONSTITUENT on BATCHREVENUERECOGNITION.CONSTITUENTID = CONSTITUENT.ID
          where ADDITIONALAPPLICATIONDESIGNATIONID = @DESIGNATIONID
          and ADDITIONALAPPLICATIONTYPECODE = @TYPECODE
          and BATCHREVENUEID = @BATCHREVENUEID
          and ADDITIONALAPPLICATIONDECLINESGIFTAID = @DECLINESGIFTAID
        and coalesce(ADDITIONALAPPLICATIONSPONSORSHIPID,'00000000-0000-0000-0000-000000000000') = coalesce(@SPONSORSHIPID,'00000000-0000-0000-0000-000000000000')
        end
        else
        begin
          select @RETURN = coalesce(@RETURN + '; ', '') + CONSTITUENT.NAME
          from dbo.BATCHREVENUESOLICITOR
          inner join dbo.CONSTITUENT on BATCHREVENUESOLICITOR.CONSTITUENTID = CONSTITUENT.ID
          where ADDITIONALAPPLICATIONDESIGNATIONID = @DESIGNATIONID
          and ADDITIONALAPPLICATIONTYPECODE = @TYPECODE
          and BATCHREVENUEID = @BATCHREVENUEID
          and ADDITIONALAPPLICATIONDECLINESGIFTAID = @DECLINESGIFTAID
        and coalesce(ADDITIONALAPPLICATIONSPONSORSHIPID,'00000000-0000-0000-0000-000000000000') = coalesce(@SPONSORSHIPID,'00000000-0000-0000-0000-000000000000')
        end

          return @RETURN
      end