UFN_GRADINGSCALE_NAMEISUNIQUE

Check that the name of the grading scale is unique.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@FACULTYID	uniqueidentifier	IN
@ID	uniqueidentifier	IN
@NAME	nvarchar(60)	IN
@ISREGISTRARCREATED	bit	IN

Definition

Copy



create function dbo.UFN_GRADINGSCALE_NAMEISUNIQUE
(
    @FACULTYID uniqueidentifier,
    @ID uniqueidentifier,
    @NAME nvarchar(60),
    @ISREGISTRARCREATED bit
)
returns bit
as begin
    declare @RETVAL int = 1;

    if (@ISREGISTRARCREATED = 1)
    begin
        if (exists (select NAME 
                    from dbo.GRADINGSCALE 
                    where ID <> @ID 
                        and NAME = @NAME
                    ))
            set @RETVAL = 0;
    end
    else
    begin
        if (exists (select NAME 
                    from dbo.GRADINGSCALE 
                    where ID <> @ID 
                        and NAME = @NAME 
                        and (FACULTYID = @FACULTYID 
                            or @ISREGISTRARCREATED = 1)
                    ))
            set @RETVAL = 0;
    end

    return @RETVAL;
end