UFN_SCHOOLGRADELEVEL_GETSCHOOLID

Returns the schoolid 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_GETSCHOOLID
        (
            @SCHOOLGRADELEVELID uniqueidentifier
        )
        returns uniqueidentifier
        with execute as caller
        as begin
            declare @SCHOOLID uniqueidentifier

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

            return @SCHOOLID;
        end