USP_DATAFORMTEMPLATE_ADD_STEP_PRELOAD_2

The load procedure used by the edit dataform template "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_STEP_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