UFN_MEMBERSHIPPROGRAM_CAMPAIGNS

This function returns all of the campaigns associated with a membership program

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPPROGRAM_CAMPAIGNS(
        @MEMBERSHIPPROGRAMID uniqueidentifier
        ) returns table
        as return
                select
                    MPC.ID,
                    MPC.CAMPAIGNID,
                    MPC.CAMPAIGNSUBPRIORITYID,
                    MPC.DATEFROM,
                    MPC.DATETO
                from
                    dbo.MEMBERSHIPPROGRAMCAMPAIGN MPC
                where
                    MPC.MEMBERSHIPPROGRAMID = @MEMBERSHIPPROGRAMID