UFN_SCHOOL_ISSINGLESCHOOL

Returns true if a single school database

Return

Return Type
bit

Definition

Copy


        CREATE function dbo.UFN_SCHOOL_ISSINGLESCHOOL()
        returns bit
        with execute as caller
        as begin
            declare @RETVAL int = 0;

            --Don't return true if this is so far a "no school" database. In that case the School field needs to still show up to prompt the user to add a school.

            SELECT @RETVAL = CASE WHEN (COUNT(dbo.SCHOOL.[ID]) = 1) THEN 1 ELSE 0 END
            FROM dbo.SCHOOL

            return @RETVAL;
        end