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