UFN_REVENUESPLIT_CAMPAIGNS

This function returns all of the campaigns associated with a revenue split.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUESPLIT_CAMPAIGNS (
                @REVENUESPLITID uniqueidentifier
            ) returns table
            as return
                select
                    REVENUESPLITCAMPAIGN.ID,
                    REVENUESPLITCAMPAIGN.CAMPAIGNID,
                    REVENUESPLITCAMPAIGN.CAMPAIGNSUBPRIORITYID
                from
                    dbo.REVENUESPLITCAMPAIGN
                where
                    REVENUESPLITCAMPAIGN.REVENUESPLITID = @REVENUESPLITID