USP_SIMPLEDATALIST_TRANSLATIONTABLEGRADE

create procedure dbo.USP_SIMPLEDATALIST_TRANSLATIONTABLEGRADE
(
    @TRANSLATIONTABLEID uniqueidentifier = null
)
as
    set nocount on;

    select ID as VALUE,
           GRADE as LABEL
    from dbo.TRANSLATIONTABLEGRADE
    where TRANSLATIONTABLEID = @TRANSLATIONTABLEID
    order by HIGHESTSCORE desc