UFN_PLANNEDGIFTADDITIONDESIGNATION_GETCAMPAIGNS

Returns a list of campaigns associated with a planned gift addition designation.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@PLANNEDGIFTADDITIONDESIGNATIONID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_PLANNEDGIFTADDITIONDESIGNATION_GETCAMPAIGNS
            (
                @PLANNEDGIFTADDITIONDESIGNATIONID uniqueidentifier
            ) 
            returns table
            as return
                select
                    PGADC.ID,
                    PGADC.CAMPAIGNID,
                    PGADC.CAMPAIGNSUBPRIORITYID,
                    c.NAME CAMPAIGNNAME
                from
                    dbo.PLANNEDGIFTADDITIONDESIGNATIONCAMPAIGN PGADC
                    inner join dbo.CAMPAIGN C on PGADC.CAMPAIGNID = C.ID
                where
                    PLANNEDGIFTADDITIONDESIGNATIONID = @PLANNEDGIFTADDITIONDESIGNATIONID