USP_DATAFORMTEMPLATE_EDIT_GROUPMEMBER

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@STARTDATE	datetime	IN	Start date

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_GROUPMEMBER
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @STARTDATE datetime
)

as
  set nocount on;

  declare @ENDDATE datetime;
  declare @COMMENTS nvarchar(300);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_GROUPMEMBER
    @ID = @ID,
    @ENDDATE = @ENDDATE output,
    @COMMENTS = @COMMENTS output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_GROUPMEMBER_2
    @ID,
    @CHANGEAGENTID,
    @STARTDATE,
    @ENDDATE,
    @COMMENTS

  return 0;