UFN_COURSE_GETGRADELEVELS

CREATE function dbo.UFN_COURSE_GETGRADELEVELS
(
    @COURSEID uniqueidentifier
)
returns table
as return 
    (select COURSEGRADELEVEL.ID,
                    COURSEGRADELEVEL.SCHOOLGRADELEVELID,
          GRADELEVEL.ABBREVIATION + ' - ' + GRADELEVEL.DESCRIPTION as LABEL
     from dbo.COURSEGRADELEVEL
      inner join dbo.SCHOOLGRADELEVEL
          on COURSEGRADELEVEL.SCHOOLGRADELEVELID = SCHOOLGRADELEVEL.ID
      inner join dbo.GRADELEVEL
          on SCHOOLGRADELEVEL.GRADELEVELID = GRADELEVEL.ID
     where COURSEID = @COURSEID)