UFN_SCHOOLGRADELEVEL_GETGRADELEVELID

Returns the gradelevelid for the school grade level

Return

Return Type
uniqueidentifier

Parameters

Parameter	Parameter Type	Mode	Description
@SCHOOLGRADELEVELID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_SCHOOLGRADELEVEL_GETGRADELEVELID
        (
            @SCHOOLGRADELEVELID uniqueidentifier
        )
        returns uniqueidentifier
        with execute as caller
        as begin
            declare @GRADELEVELID uniqueidentifier

            select @GRADELEVELID = 
                        dbo.SCHOOLGRADELEVEL.[GRADELEVELID]
                        from dbo.SCHOOLGRADELEVEL
                        where dbo.SCHOOLGRADELEVEL.[ID] = @SCHOOLGRADELEVELID;

            return @GRADELEVELID;
        end