UFN_REVENUESPLIT_GETCAMPAIGNS

Returns all campaigns for a given revenue detail record.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@REVENUESPLITID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_REVENUESPLIT_GETCAMPAIGNS(@REVENUESPLITID uniqueidentifier)
            returns table
            AS            
            return 
            (
                select 
                    REVENUESPLITCAMPAIGN.[ID],
                    REVENUESPLITCAMPAIGN.[CAMPAIGNID],
                    REVENUESPLITCAMPAIGN.[CAMPAIGNSUBPRIORITYID]
                from dbo.REVENUESPLITCAMPAIGN
                where REVENUESPLITCAMPAIGN.REVENUESPLITID = @REVENUESPLITID
            )