UFN_GRADELEVEL_EXISTSINSCHOOL

Check that the grade level belongs to school.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@SCHOOLID	uniqueidentifier	IN
@GRADELEVELDID	uniqueidentifier	IN

Definition

Copy



        create function dbo.UFN_GRADELEVEL_EXISTSINSCHOOL
        (
            @SCHOOLID uniqueidentifier,
            @GRADELEVELDID uniqueidentifier
        )
        returns bit
        as begin
            declare @RETVAL int = 1;

            SELECT @RETVAL = COUNT(dbo.SCHOOLGRADELEVEL.[ID])
            FROM dbo.SCHOOLGRADELEVEL
            WHERE dbo.SCHOOLGRADELEVEL.[SCHOOLID] = @SCHOOLID AND 
                dbo.SCHOOLGRADELEVEL.[GRADELEVELID] = @GRADELEVELDID

            return @RETVAL;
        end