USP_DATAFORMTEMPLATE_ADD_STEPCOMPLETED_PRELOAD_2

The load procedure used by the edit dataform template "Completed Step Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@OWNERID	uniqueidentifier	INOUT	Owner
@PROSPECTNAME	nvarchar(154)	INOUT	Prospect name
@PROSPECTID	uniqueidentifier	INOUT

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STEPCOMPLETED_PRELOAD_2 
          (
            @PROSPECTPLANID uniqueidentifier,
            @OWNERID uniqueidentifier = null output,
            @PROSPECTNAME nvarchar(154) = null output,
            @PROSPECTID uniqueidentifier = null output
          ) as begin
            set nocount on;

            select
              @OWNERID = PP.PRIMARYMANAGERFUNDRAISERID,
              @PROSPECTNAME = NF.NAME,
              @PROSPECTID = PP.PROSPECTID
            from dbo.PROSPECTPLAN PP
            cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(PP.PROSPECTID) NF
            where PP.ID = @PROSPECTPLANID;

            return 0;
          end