USP_DATAFORMTEMPLATE_ADD_STEPCOMPLETED_PRELOAD

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

Parameters

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

Definition

Copy



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

                        select
                            @FUNDRAISERID = PP.PRIMARYMANAGERFUNDRAISERID,
                            @PROSPECTNAME = C.NAME
                        from dbo.PROSPECTPLAN PP
                        inner join dbo.CONSTITUENT C on PP.PROSPECTID = C.ID
                        where
                            PP.ID = @PROSPECTPLANID;

                        return 0;
                    end