USP_DATAFORMTEMPLATE_ADD_FAFNFGCAMPAIGNLEVELHIERARCHY_PRELOAD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CURRENTAPPUSERID | uniqueidentifier | IN | |
| @SITEREQUIRED | bit | INOUT | |
| @SITES | xml | INOUT | |
| @NFGCAMPAIGNID | uniqueidentifier | INOUT | |
| @PARENTID | uniqueidentifier | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAFNFGCAMPAIGNLEVELHIERARCHY_PRELOAD
(
@CURRENTAPPUSERID uniqueidentifier,
@SITEREQUIRED bit = null output,
@SITES xml = null output,
@NFGCAMPAIGNID uniqueidentifier = null output,
@PARENTID uniqueidentifier
)
as
set nocount on;
select @NFGCAMPAIGNID = FAFNFGCampaignLevel.NFGCAMPAIGNID from dbo.FAFNFGCampaignLevel where FAFNFGCampaignLevel.ID = @PARENTID
return 0;