UFN_MEMBERSHIPLEVEL_CAMPAIGNS

This function returns all of the campaigns associated with a membership level.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@MEMBERSHIPLEVELID	uniqueidentifier	IN

Definition

Copy



create function dbo.UFN_MEMBERSHIPLEVEL_CAMPAIGNS(
        @MEMBERSHIPLEVELID uniqueidentifier
        ) returns table
        as 
            return
                select
                    MLC.ID,
                    MLC.CAMPAIGNID,
                    MLC.CAMPAIGNSUBPRIORITYID,
                    MLC.DATEFROM,
                    MLC.DATETO
                from
                    dbo.MEMBERSHIPLEVELCAMPAIGN MLC
                where
                    MLC.MEMBERSHIPLEVELID = @MEMBERSHIPLEVELID