USP_DATALIST_CATEGORY

Returns a list of categories for a particular class.

Parameters

Parameter	Parameter Type	Mode	Description
@CLASSID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



CREATE procedure dbo.USP_DATALIST_CATEGORY(@CLASSID uniqueidentifier)
as
    set nocount on;

    select CLASSCATEGORY.ID,
        CLASSCATEGORY.NAME,
        DEFAULTNAME,
        ISGRADED,
        GRADINGSCALE.NAME "GRADINGSCALE",
        MAXPOINTS,
        AVERAGINGMETHOD
    from dbo.CLASSCATEGORY
        left outer join dbo.GRADINGSCALE on CLASSCATEGORY.GRADINGSCALEID = GRADINGSCALE.ID
    where CLASSID = @CLASSID