UFN_BUILDSTEPFUNDRAISERSLIST

Returns a string holding the list of fundraisers associated with a prospect plan, along with the fundraiser's role(s) in parentheses.

Return

Return Type
nvarchar(max)

Parameters

Parameter	Parameter Type	Mode	Description
@INTERACTIONID	uniqueidentifier	IN

Definition

Copy


            create function dbo.UFN_BUILDSTEPFUNDRAISERSLIST
            (
                @INTERACTIONID uniqueidentifier
            )
            returns nvarchar(max)
            with execute as caller
            as begin                
                declare @OUTPUT nvarchar(max);

                select
                    @OUTPUT = dbo.UDA_BUILDLIST(dbo.UFN_BUILDSTEPFUNDRAISERNAMEWITHROLE(@INTERACTIONID, FUNDRAISERID))
                from dbo.INTERACTIONADDITIONALFUNDRAISER where INTERACTIONID = @INTERACTIONID;

                return @OUTPUT;
            end