USP_DATAFORMTEMPLATE_VIEW_SCHEDULINGEXCEPTIONS

The load procedure used by the view dataform template "Exceptions To Check View"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@DIFFERENTGENDER	bit	INOUT	Assigned different gender than course
@DIFFERENTSCHOOL	bit	INOUT	Assigned different school than course
@DIFFERENTGRADELEVEL	bit	INOUT	Assigned different grade level than course
@ALREADYTAKEN	bit	INOUT	Has already taken course
@ALREADYREQUESTED	bit	INOUT	Has already requested course

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_SCHEDULINGEXCEPTIONS
(
    @DATALOADED bit = 0 output,
    @DIFFERENTGENDER bit = null output,
    @DIFFERENTSCHOOL bit = null output,
    @DIFFERENTGRADELEVEL bit = null output,
    @ALREADYTAKEN bit = null output,
    @ALREADYREQUESTED bit = null output
)
as
    set nocount on

    set @DATALOADED = 0

    select @DATALOADED = 1,
        @DIFFERENTGENDER = DIFFERENTGENDER,
        @DIFFERENTSCHOOL = DIFFERENTSCHOOL,
        @DIFFERENTGRADELEVEL = DIFFERENTGRADELEVEL,
        @ALREADYTAKEN = ALREADYTAKEN,
        @ALREADYREQUESTED = ALREADYREQUESTED
    from dbo.SCHEDULINGEXCEPTION

    return 0