UFN_GRADEBOOKSPECIALCHARACTER_GETSPECIALCHARACTERS

Function returns the special characters for a faculty.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@FACULTYID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_GRADEBOOKSPECIALCHARACTER_GETSPECIALCHARACTERS
(
  @FACULTYID uniqueidentifier  
)
returns table
as return (

  select ID,
         NAME,
         SHORTDESCRIPTION,
         USEINCALCULATIONS,
         PERCENTOFGRADE,
         CANBEDROPPED,
         ISREGISTRARCREATED
  from dbo.GRADEBOOKSPECIALCHARACTER
  where FACULTYID = @FACULTYID or ISREGISTRARCREATED = 1
)