USP_DATALIST_CLASSASSIGNMENT

Returns all Class Assignment records.

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_CLASSASSIGNMENT
                (
                    @CLASSID uniqueidentifier
                )
as
    set nocount on;

    select 
        CLASSASSIGNMENT.[ID],
        CLASSASSIGNMENT.[ASSIGNMENTID],
        ASSIGNMENT.[NAME],
        ASSIGNMENT.[DESCRIPTION],
        ASSIGNMENT.[MAXPOINTS],
        CLASSASSIGNMENT.[STUDENTDUEDATE]
    from dbo.CLASSASSIGNMENT
        left join dbo.ASSIGNMENT on dbo.CLASSASSIGNMENT.ASSIGNMENTID = dbo.ASSIGNMENT.ID
    where
        dbo.CLASSASSIGNMENT.CLASSID = @CLASSID