UFN_GRADEBOOKSPECIALCHARACTER_SPECIALCHARACTERISGRADE
Determine if the special character short description is the same as a grade.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SHORTDESCRIPTION | nvarchar(10) | IN | |
| @FACULTYID | uniqueidentifier | IN | |
| @ISREGISTRARCREATED | bit | IN |
Definition
Copy
create function dbo.UFN_GRADEBOOKSPECIALCHARACTER_SPECIALCHARACTERISGRADE(
@SHORTDESCRIPTION nvarchar(10),
@FACULTYID uniqueidentifier,
@ISREGISTRARCREATED bit
)
returns bit
with execute as caller
as begin
declare @RETVAL integer = 0;
if (exists (select GRADE, FACULTYID, ISREGISTRARCREATED
from dbo.GRADINGSCALEGRADE
inner join dbo.GRADINGSCALE
on GRADINGSCALEID = GRADINGSCALE.ID
where GRADE = @SHORTDESCRIPTION
and (@ISREGISTRARCREATED = 1
or ISREGISTRARCREATED = 1
or FACULTYID = @FACULTYID)
))
set @RETVAL = 1;
return @RETVAL;
end