USP_RECORDOPERATION_RESPONSETOGGLEACTIVE

Executes the "Response: Toggle Active" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being updated.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the update.

Definition

Copy



CREATE procedure dbo.USP_RECORDOPERATION_RESPONSETOGGLEACTIVE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

  if @CHANGEAGENTID is null  
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  update
    dbo.RESPONSE
  set
    ISINACTIVE = (1 - ISINACTIVE),
    CHANGEDBYID = @CHANGEAGENTID,
    DATECHANGED = getdate()
  where
    RESPONSE.ID = @ID;

  return 0;