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;