UFN_CAMPAIGN_DESIGNATIONS

This function returns the designation campaigns for a campaign.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CAMPAIGN_DESIGNATIONS (
                @CAMPAIGNID uniqueidentifier
            ) returns table
            as return
                select
                    DESIGNATIONCAMPAIGN.ID,
                    DESIGNATIONCAMPAIGN.DESIGNATIONID,
                    DESIGNATIONCAMPAIGN.CAMPAIGNSUBPRIORITYID,
                    DESIGNATIONCAMPAIGN.DATEFROM,
                    DESIGNATIONCAMPAIGN.DATETO,
                    DESIGNATIONCAMPAIGN.SEQUENCE
                from
                    dbo.DESIGNATIONCAMPAIGN
                where
                    DESIGNATIONCAMPAIGN.CAMPAIGNID = @CAMPAIGNID