USP_DATALIST_TRANSLATIONTABLEGRADE

Returns a list of translation table grades.

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_TRANSLATIONTABLEGRADE(@CONTEXTID uniqueidentifier)
as
    set nocount on;

    select ID,
           TRANSLATIONTABLEID,
           GRADE,
           NUMERICEQUIVALENT,
           CREDITAWARDED,
           HIGHESTSCORE,
           LOWESTSCORE
    from dbo.TRANSLATIONTABLEGRADE
    where TRANSLATIONTABLEID = @CONTEXTID
    order by HIGHESTSCORE desc