UFN_SCHOOL_GETGRADELEVELS

Returns the grade levels associated with a given school.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@SCHOOLID	uniqueidentifier	IN

Definition

Copy



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