UFN_CAMPAIGNPRIORITY_CAMPAIGNSUBPRIORITIES

This function returns the campaign subpriorities for a campaign priority given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CAMPAIGNPRIORITYID	uniqueidentifier	IN

Definition

Copy



            CREATE function dbo.UFN_CAMPAIGNPRIORITY_CAMPAIGNSUBPRIORITIES (
                @CAMPAIGNPRIORITYID uniqueidentifier
            ) returns table
            as return
                select
                    CAMPAIGNSUBPRIORITY.ID,
                    CAMPAIGNSUBPRIORITY.CAMPAIGNSUBPRIORITYNAMECODEID,
                    CAMPAIGNSUBPRIORITY.GOAL,
                    CAMPAIGN.BASECURRENCYID,
                    CAMPAIGNSUBPRIORITY.ORGANIZATIONAMOUNT,
                    CAMPAIGNSUBPRIORITY.CURRENCYEXCHANGERATEID
                from
                    dbo.CAMPAIGNSUBPRIORITY
                    inner join dbo.CAMPAIGNPRIORITY on CAMPAIGNSUBPRIORITY.CAMPAIGNPRIORITYID = CAMPAIGNPRIORITY.ID
                    inner join dbo.CAMPAIGN on CAMPAIGNPRIORITY.CAMPAIGNID = CAMPAIGN.ID
                where 
                    CAMPAIGNSUBPRIORITY.CAMPAIGNPRIORITYID = @CAMPAIGNPRIORITYID