USP_DATALIST_STUDENT_CLASS_MEETING_GROUP

Returns all Student Class Meeting Group 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_STUDENT_CLASS_MEETING_GROUP
                (
                    @CLASSID uniqueidentifier
                )
                as
                    set nocount on;

                select 
                    STUDENTCLASSMEETINGGROUP.[ID],
                    dbo.CONSTITUENT.ID AS STUDENTID,
                    CONSTITUENT.NAME
                from
                    dbo.STUDENTCLASSMEETINGGROUP
                    left join dbo.CLASSMEETINGGROUP on dbo.STUDENTCLASSMEETINGGROUP.CLASSMEETINGGROUPID = dbo.CLASSMEETINGGROUP.ID
                    left join dbo.STUDENTCOURSE on dbo.STUDENTCLASSMEETINGGROUP.STUDENTCOURSEID = dbo.STUDENTCOURSE.ID
                    left join dbo.CONSTITUENT on dbo.STUDENTCOURSE.STUDENTID = dbo.CONSTITUENT.ID
                where
                    dbo.CLASSMEETINGGROUP.CLASSID = @CLASSID