USP_SIMPLEDATALIST_SCHOOLGRADELEVELDESCRIPTION

            CREATE procedure dbo.USP_SIMPLEDATALIST_SCHOOLGRADELEVELDESCRIPTION
            (
                @SCHOOLID uniqueidentifier = null
            )
            as
                select 
                    dbo.SCHOOLGRADELEVEL.[ID] as VALUE, 
                    dbo.GRADELEVEL.[ABBREVIATION] + ' - ' + dbo.GRADELEVEL.[DESCRIPTION] as LABEL
                from dbo.SCHOOLGRADELEVEL
                inner join dbo.GRADELEVEL on dbo.SCHOOLGRADELEVEL.[GRADELEVELID] = GRADELEVEL.[ID]
                where dbo.SCHOOLGRADELEVEL.[SCHOOLID] = @SCHOOLID
                order by dbo.GRADELEVEL.[SEQUENCE]