UFN_GRADINGSCALE_GETGRADES

Function returns the grades for a grading scale.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@GRADINGSCALEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_GRADINGSCALE_GETGRADES
(
    @GRADINGSCALEID uniqueidentifier
)
returns table
as return(
    select ID,
           GRADE,
           NUMERICEQUIVALENT,
           HIGHESTSCORE,
           LOWESTSCORE
    from dbo.GRADINGSCALEGRADE
    where GRADINGSCALEID = @GRADINGSCALEID
)