USP_DATAFORMTEMPLATE_VIEW_PROSPECTSEGMENTATIONSEGMENT_PAGEEXPRESSIONS

The load procedure used by the view dataform template "Prospect Segmentation Segment Page Expression View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	nvarchar(200)	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@PROSPECTSEGMENTATIONID	uniqueidentifier	INOUT	PROSPECTSEGMENTATIONID
@NAME	nvarchar(100)	INOUT	Name
@PRIMARYSECTIONLABEL	nvarchar(20)	INOUT	Primary section label
@SECONDARYSECTIONLABEL	nvarchar(20)	INOUT	Primary section label
@SECONDARYSECTIONLABEL2	nvarchar(20)	INOUT	Primary section label 2
@USESECONDARYVARIABLE2	bit	INOUT	Use secondary variable 2

Definition

Copy



                    create procedure dbo.USP_DATAFORMTEMPLATE_VIEW_PROSPECTSEGMENTATIONSEGMENT_PAGEEXPRESSIONS (
                    @ID                     nvarchar(200),
                    @CURRENTAPPUSERID       uniqueidentifier,
                    @DATALOADED             bit = 0 output,
          @PROSPECTSEGMENTATIONID uniqueidentifier = null output,
                    @NAME                   nvarchar(100)= null output,
          @PRIMARYSECTIONLABEL    nvarchar(20) = null output,
          @SECONDARYSECTIONLABEL  nvarchar(20) = null output,
          @SECONDARYSECTIONLABEL2 nvarchar(20) = null output,
          @USESECONDARYVARIABLE2  bit = null output                     
                ) as
                    set nocount on;

                    declare @IDSUBSTRING nvarchar(36)

          declare @PRIMARYPROSPECTSEGMENTATIONID    uniqueidentifier
          declare @SECONDARYPROSPECTSEGMENTATIONID  uniqueidentifier
                    declare @PRIMARYSECTIONID                 uniqueidentifier
          declare @SECONDARYSECTIONID               uniqueidentifier 

                    set @IDSUBSTRING = substring(@ID,1,36)
                    if len(@IDSUBSTRING) = 36
                        set @PRIMARYSECTIONID = cast(@IDSUBSTRING as uniqueidentifier)

                    set @IDSUBSTRING = substring(@ID,37,36)
                    if len(@IDSUBSTRING) = 36
                        set @SECONDARYSECTIONID = cast(@IDSUBSTRING as uniqueidentifier)

          select
            @PRIMARYSECTIONLABEL =            PRIMARYSECTION.LABEL,
            @PRIMARYPROSPECTSEGMENTATIONID =  PRIMARYVARIABLE.PROSPECTSEGMENTATIONID
          from
            dbo.PROSPECTSEGMENTATIONSECTION PRIMARYSECTION
          left join dbo.PROSPECTSEGMENTATIONVARIABLE PRIMARYVARIABLE on
              PRIMARYSECTION.VARIABLEID = PRIMARYVARIABLE.ID
          where
            PRIMARYSECTION.ID = @PRIMARYSECTIONID

          select
            @USESECONDARYVARIABLE2 =            case SECONDARYSECTION.LABEL2
                                                  when '' then 0
                                                  else 1
                                                end,
            @SECONDARYSECTIONLABEL  =           SECONDARYSECTION.LABEL,
            @SECONDARYSECTIONLABEL2 =           SECONDARYSECTION.LABEL2,
            @SECONDARYPROSPECTSEGMENTATIONID =  SECONDARYVARIABLE.PROSPECTSEGMENTATIONID
          from
            dbo.PROSPECTSEGMENTATIONSECTION SECONDARYSECTION 
          left join dbo.PROSPECTSEGMENTATIONVARIABLE SECONDARYVARIABLE on
              SECONDARYSECTION.VARIABLEID = SECONDARYVARIABLE.ID
          where
            SECONDARYSECTION.ID = @SECONDARYSECTIONID

          if @PRIMARYPROSPECTSEGMENTATIONID = @SECONDARYPROSPECTSEGMENTATIONID
          begin
            select
                          @DATALOADED = 1,
                          @NAME = NAME,
              @PROSPECTSEGMENTATIONID = ID
            from
              dbo.PROSPECTSEGMENTATION
            where 
              ID = @PRIMARYPROSPECTSEGMENTATIONID
          end