USP_DATAFORMTEMPLATE_VIEW_GROUPGOALCOMMITTEEINFO

The load procedure used by the view dataform template "Group Goal Committee Info View Form "

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@COMMITTEEID	uniqueidentifier	INOUT	Committee ID
@COMMITTEENAME	nvarchar(100)	INOUT	Committee name
@GROUPGOALID	uniqueidentifier	INOUT	Group goal ID
@GROUPGOALNAME	nvarchar(20)	INOUT	Group goal name

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_GROUPGOALCOMMITTEEINFO
            (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @COMMITTEEID uniqueidentifier = null output,
            @COMMITTEENAME nvarchar(100) = null output,
            @GROUPGOALID uniqueidentifier = null output,
            @GROUPGOALNAME nvarchar(20) = null output
            )
            as
            set nocount on;

            select
            @DATALOADED=1,
            @COMMITTEEID=COMMITTEE.[ID],
            @COMMITTEENAME=CONSTITUENT.[KEYNAME],
            @GROUPGOALID=GROUPGOAL.[ID],
            @GROUPGOALNAME=GROUPGOAL.[NAME]
            from
            dbo.GROUPGOAL
            inner join
            dbo.COMMITTEE on COMMITTEE.[ID]=GROUPGOAL.[GROUPID]
            inner join
            dbo.CONSTITUENT on COMMITTEE.[ID]=CONSTITUENT.[ID]
            left join GROUPGOALUNITCODE
            on GROUPGOALUNITCODE.[ID] = GROUPGOAL.[GROUPGOALUNITCODEID]
            where
            GROUPGOAL.[ID]=@ID


            return 0;