USP_DATAFORMTEMPLATE_ADD_MOBILE_STEP_PRELOAD
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @PROSPECTPLANID | uniqueidentifier | IN | |
| @OWNERID | uniqueidentifier | INOUT | |
| @PROSPECTNAME | nvarchar(154) | INOUT | |
| @PROSPECTID | uniqueidentifier | INOUT |
Definition
Copy
create procedure dbo.USP_DATAFORMTEMPLATE_ADD_MOBILE_STEP_PRELOAD
(
@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