USP_DATAFORMTEMPLATE_ADD_ASSIGNVOLUNTEERS_PRELOAD

The load procedure used by the edit dataform template "Assign Volunteers Add Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@JOBOCCURRENCEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@JOBNAME	nvarchar(50)	INOUT	Job
@OCCURRENCENAME	nvarchar(30)	INOUT	Occurrence
@STARTTIME	UDT_HOURMINUTE	INOUT
@ENDTIME	UDT_HOURMINUTE	INOUT
@NEEDED	int	INOUT	Needed

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_ASSIGNVOLUNTEERS_PRELOAD
(
    @JOBOCCURRENCEID uniqueidentifier, 
    @JOBNAME nvarchar(50) = null output,
    @OCCURRENCENAME nvarchar(30) = null output,
    @STARTTIME dbo.UDT_HOURMINUTE = null output,
    @ENDTIME dbo.UDT_HOURMINUTE = null output,
    @NEEDED int = null output
)
 as
    set nocount on;

    select 
        @JOBNAME = JOB.NAME,
        @OCCURRENCENAME = JOBOCCURRENCE.DESCRIPTION,
        @STARTTIME = JOBOCCURRENCE.STARTTIME,
        @ENDTIME = JOBOCCURRENCE.ENDTIME,
        @NEEDED = JOBOCCURRENCE.VOLUNTEERSNEEDED
    from dbo.JOBOCCURRENCE
        inner join dbo.JOB on JOBOCCURRENCE.JOBID = JOB.ID
    where JOBOCCURRENCE.ID = @JOBOCCURRENCEID;

    return 0;