USP_IDSETREGISTER_SETROWCOUNT

Sets the row count for an ID Set.

Parameters

Parameter	Parameter Type	Mode
@IDSETREGISTERID	uniqueidentifier	IN
@NUMROWS	int	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.[USP_IDSETREGISTER_SETROWCOUNT]
(
  @IDSETREGISTERID uniqueidentifier,
  @NUMROWS int,
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  if @IDSETREGISTERID is not null
    begin
      if @CHANGEAGENTID is null
        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

      if @NUMROWS is null or @NUMROWS < 0
        set @NUMROWS = 0;

      update dbo.[IDSETREGISTER] set
        [NUMROWS] = @NUMROWS,
        [CHANGEDBYID] = @CHANGEAGENTID,
        [DATECHANGED] = GetDate()
      where [ID] = @IDSETREGISTERID;
    end

  return 0;