USP_DATAFORMTEMPLATE_VIEW_CAMPAIGNSUBPRIORITY_CAMPAIGNPRIORITYINFO

The load procedure used by the view dataform template "Campaign Subpriority Campaign Priority Info View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PRIORITYID	uniqueidentifier	INOUT	Priority ID
@PRIORITYNAME	nvarchar(200)	INOUT	Priority name

Definition

Copy



        create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CAMPAIGNSUBPRIORITY_CAMPAIGNPRIORITYINFO (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @PRIORITYID uniqueidentifier = null output,
            @PRIORITYNAME nvarchar(200) = null output
        ) as
        set nocount on;

        select
            @DATALOADED=1,
            @PRIORITYID=CAMPAIGNPRIORITY.ID,
            @PRIORITYNAME=CAMPAIGNPRIORITYTYPECODE.DESCRIPTION
        from dbo.CAMPAIGNSUBPRIORITY
            inner join dbo.CAMPAIGNPRIORITY on CAMPAIGNSUBPRIORITY.CAMPAIGNPRIORITYID=CAMPAIGNPRIORITY.ID
            inner join dbo.CAMPAIGNPRIORITYTYPECODE on CAMPAIGNPRIORITY.CAMPAIGNPRIORITYTYPECODEID  = CAMPAIGNPRIORITYTYPECODE.ID
        where CAMPAIGNSUBPRIORITY.ID=@ID

        return 0;