UFN_REVENUEBATCH_GETSPLITCAMPAIGNS

Returns campaigns for a revenue batch split.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@BATCHREVENUESPLITID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_REVENUEBATCH_GETSPLITCAMPAIGNS(@BATCHREVENUESPLITID uniqueidentifier)
            returns table
            as return
                select 
                    ID, CAMPAIGNID, CAMPAIGNSUBPRIORITYID, REVENUESPLITCAMPAIGNID
                from
                    dbo.BATCHREVENUESPLITCAMPAIGN
                where
                    BATCHREVENUESPLITID = @BATCHREVENUESPLITID;