USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP_3
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTAPPUSERID uniqueidentifier,
                @NAME nvarchar(100),
                @DESCRIPTION nvarchar(255)
            ) 
            as
            set nocount on;
            declare @PARENTRESEARCHGROUPID uniqueidentifier = null;
            declare @SITES xml = null;
            exec dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP_LOAD 
                @ID = @ID,
                @SITES = @SITES output,
        @PARENTRESEARCHGROUPID = @PARENTRESEARCHGROUPID output;

            exec dbo.USP_DATAFORMTEMPLATE_EDIT_RESEARCHGROUP_4
                @ID,
                @CHANGEAGENTID,
                @CURRENTAPPUSERID,
                @NAME,
                @DESCRIPTION,
                @SITES,
                @PARENTRESEARCHGROUPID;