USP_DATAFORMTEMPLATE_ADD_ASSIGNPROSPECTREQUEST_PRELOAD

The load procedure used by the edit dataform template "Fundraiser Assignment Request Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@FUNDRAISERID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@FUNDRAISER	nvarchar(700)	INOUT
@STARTDATE	datetime	INOUT	Start date

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ASSIGNPROSPECTREQUEST_PRELOAD (
                        @FUNDRAISERID uniqueidentifier,
                        @FUNDRAISER nvarchar(700) = null output,
                        @STARTDATE datetime = null output
                    ) as begin
                        set nocount on;

                        set @STARTDATE = getdate();

                        select @FUNDRAISER=NF.NAME
                        from dbo.UFN_CONSTITUENT_DISPLAYNAME(@FUNDRAISERID) NF

                        return 0;
                    end