USP_DATALIST_GRADELEVEL

        CREATE procedure dbo.USP_DATALIST_GRADELEVEL
        as
            set nocount on;

            declare @MINSEQUENCE int = (select min(SEQUENCE) from dbo.GRADELEVEL)
            declare @MAXSEQUENCE int = (select max(SEQUENCE) from dbo.GRADELEVEL)

            select GRADELEVEL.ID,
                   GRADELEVEL.DESCRIPTION,
                   GRADELEVEL.ABBREVIATION,
                   case when GRADELEVEL.SEQUENCE = @MINSEQUENCE then 1 else 0 end as ISMINSEQUENCE,
                   case when GRADELEVEL.SEQUENCE = @MAXSEQUENCE then 1 else 0 end as ISMAXSEQUENCE,
                   GRADELEVEL.ABBREVIATION + '- ' + dbo.GRADELEVEL.DESCRIPTION as LONGDESCRIPTION
            from dbo.GRADELEVEL
            order by SEQUENCE ASC