USP_MKTSEGMENTLIST_SHOWINQUERYDESIGNER

Executes the "List Segment: Show in Query Designer" 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_MKTSEGMENTLIST_SHOWINQUERYDESIGNER]
(
  @ID uniqueidentifier,    --This is the MKTSEGMENTID

  @CHANGEAGENTID uniqueidentifier = null
)
as
  set nocount on;

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

  exec dbo.[USP_MKTSEGMENTLIST_TOGGLEQUERYVIEWS] @ID, 1, @CHANGEAGENTID;

  return 0;