UFN_GRADINGSCALEGRADE_GRADEISSPECIALCHARACTER

Determine if the value for the grading scale grade is the same as any special character.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@GRADE	nvarchar(3)	IN
@GRADINGSCALEID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_GRADINGSCALEGRADE_GRADEISSPECIALCHARACTER
(
    @GRADE nvarchar(3),
    @GRADINGSCALEID uniqueidentifier
)
returns bit
as begin
    declare @RETVAL integer = 0;
    declare @FACULTYID uniqueidentifier;
    declare @ISREGISTRARCREATED bit;

    select @FACULTYID = FACULTYID, 
           @ISREGISTRARCREATED = ISREGISTRARCREATED
    from dbo.GRADINGSCALE
    where ID = @GRADINGSCALEID

    if (exists (select SHORTDESCRIPTION
                from dbo.GRADEBOOKSPECIALCHARACTER
                where SHORTDESCRIPTION = @GRADE
                    and (@ISREGISTRARCREATED = 1 
                        or ISREGISTRARCREATED = 1 
                        or FACULTYID = @FACULTYID)
        ))
        set @RETVAL = 1;

    return @RETVAL;
end