UFN_DESIGNATION_CAMPAIGNS

This function returns the campaigns for a designation.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@DESIGNATIONID	uniqueidentifier	IN

Definition

Copy



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