USP_DATAFORMTEMPLATE_ADD_GRADINGSCALEFACULTYCOPY_PRELOAD

The load procedure used by the edit dataform template "Grading Scale Faculty Copy Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@GRADINGSCALEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DESCRIPTION	nvarchar(150)	INOUT	Description
@GRADES	xml	INOUT	Grades

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_GRADINGSCALEFACULTYCOPY_PRELOAD
(
    @GRADINGSCALEID uniqueidentifier,
    @DESCRIPTION nvarchar(150) = null output,
    @GRADES xml = null output
)
as
    set nocount on;

    select @DESCRIPTION = DESCRIPTION,
        @GRADES = (select GRADE, 
                          NUMERICEQUIVALENT, 
                          HIGHESTSCORE, 
                          LOWESTSCORE 
                   from dbo.GRADINGSCALEGRADE 
                   where GRADINGSCALEID = @GRADINGSCALEID
                   order by NUMERICEQUIVALENT desc
                   for xml raw('ITEM'),type,elements,root('GRADES'),BINARY BASE64)
    from dbo.GRADINGSCALE
    where ID = @GRADINGSCALEID

    return 0;