USP_DATAFORMTEMPLATE_VIEW_RESEARCHGROUPPOPULATEHELPER

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@POPULATEMETHODCODE	tinyint	INOUT
@IDSETREGISTERID	uniqueidentifier	INOUT
@RESEARCHGROUPCRITERIA	xml	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RESEARCHGROUPPOPULATEHELPER (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
          @POPULATEMETHODCODE tinyint = null output,
          @IDSETREGISTERID uniqueidentifier = null output,
          @RESEARCHGROUPCRITERIA xml = null output
                ) as
                    set nocount on;

                    select
                        @DATALOADED = 1,
            @POPULATEMETHODCODE = POPULATEMETHODCODE,
            @RESEARCHGROUPCRITERIA = dbo.UFN_RESEARCHGROUP_GETCRITERIA_TOITEMLISTXML(ID),
            @IDSETREGISTERID = IDSETREGISTERID
                    from
                        dbo.RESEARCHGROUP
                    where
                        ID = @ID;