USP_DATAFORMTEMPLATE_VIEW_CAMPAIGNHIERARCHY

The load procedure used by the view dataform template "Campaign hierarchy"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CAMPAIGNHIERARCHY	xml	INOUT	CAMPAIGNHIERARCHY

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CAMPAIGNHIERARCHY
(
    @DATALOADED bit = 0 output,
    @CAMPAIGNHIERARCHY xml = null output
)
as
    set nocount on;

    select @DATALOADED = 1,
           @CAMPAIGNHIERARCHY = dbo.UFN_CAMPAIGNHIERARCHY_TOXML(null);

    return 0;