UFN_COURSE_GETFIRSTGRADELEVELSEQUENCE

                create function dbo.UFN_COURSE_GETFIRSTGRADELEVELSEQUENCE
                (
                    @ID uniqueidentifier
                )
                returns int
                as
                begin
                    declare @SEQUENCE int;

                    select top 1 @SEQUENCE = GRADELEVEL.SEQUENCE
                    from dbo.COURSEGRADELEVEL
                    inner join dbo.SCHOOLGRADELEVEL 
                        on COURSEGRADELEVEL.SCHOOLGRADELEVELID = SCHOOLGRADELEVEL.ID
                    inner join dbo.GRADELEVEL 
                        on SCHOOLGRADELEVEL.GRADELEVELID = GRADELEVEL.ID
                    where dbo.COURSEGRADELEVEL.COURSEID = @ID
                    order by dbo.GRADELEVEL.SEQUENCE

                    return @SEQUENCE
                end