USP_DATAFORMTEMPLATE_EDITLOAD_BULKASSIGNSOLICITORS

The load procedure used by the edit dataform template "Bulk Assign Prospects Edit Data Form"

Parameters

Parameter Parameter Type Mode Description
@DATALOADED bit INOUT Output parameter indicating whether or not data was actually loaded.
@FUNDRAISERID uniqueidentifier INOUT Load prospects that are currently assigned to
@ASSIGNMENTS xml INOUT Assignments
@ASSIGNTOID uniqueidentifier INOUT Assign selected prospects to

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BULKASSIGNSOLICITORS(
    @DATALOADED bit = 0 output,
    @FUNDRAISERID uniqueidentifier = null output,
    @ASSIGNMENTS xml = null output,
    @ASSIGNTOID uniqueidentifier = null output
)
as

    set nocount on;

    -- this load spec does nothing

    set @DATALOADED = 1;

    return 0;