UFN_CLASS_GETCATEGORIES

Returns the categories for a given class.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@CLASSID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_CLASS_GETCATEGORIES
(
    @CLASSID uniqueidentifier
)
returns table
as return(

    select
        ID,
        NAME,
        DEFAULTNAME,
        ISGRADED,
        GRADINGSCALEID,
        MAXPOINTS,
        AVERAGINGMETHODCODE,
        TOTALGRADEPERCENTAGE
    from 
        dbo.CLASSCATEGORY
    where 
        CLASSID = @CLASSID
)