USP_SIMPLEDATALIST_GRADELEVEL_ABBREVIATIONANDDESCRIPTION

Grade level abbreviation and description list

Definition

Copy


        CREATE procedure dbo.USP_SIMPLEDATALIST_GRADELEVEL_ABBREVIATIONANDDESCRIPTION
        as
          select 
                dbo.GRADELEVEL.ID as VALUE
                dbo.GRADELEVEL.ABBREVIATION + ' - ' + dbo.GRADELEVEL.[DESCRIPTION] as LABEL
            from dbo.GRADELEVEL
            order by dbo.GRADELEVEL.SEQUENCE ASC