USP_SIMPLEDATALIST_CLASS_GRADELEVEL

            CREATE procedure dbo.USP_SIMPLEDATALIST_CLASS_GRADELEVEL
            (
                @CLASSID uniqueidentifier
            )
            as
                select 
                    dbo.GRADELEVEL.[ID] as VALUE, 
                    dbo.GRADELEVEL.[ABBREVIATION] as LABEL
                from dbo.SCHOOLGRADELEVEL
                    inner join dbo.GRADELEVEL on SCHOOLGRADELEVEL.[GRADELEVELID] = GRADELEVEL.[ID]
                    inner join dbo.COURSEGRADELEVEL on SCHOOLGRADELEVEL.ID = COURSEGRADELEVEL.SCHOOLGRADELEVELID
                    inner join dbo.CLASS on COURSEGRADELEVEL.COURSEID = CLASS.COURSEID                    
                where CLASS.ID = @CLASSID
                order by dbo.GRADELEVEL.[SEQUENCE]