USP_MKTSEGMENTLIST_UPDATECONSOLIDATEDID
Associates a list segment with a consolidated query view so that the results of the query view contain the list data.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | |
| @CONSOLIDATEDQUERYVIEWCATALOGID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.[USP_MKTSEGMENTLIST_UPDATECONSOLIDATEDID]
(
@ID uniqueidentifier,
@CONSOLIDATEDQUERYVIEWCATALOGID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null
)
as
set nocount on;
begin try
if @CHANGEAGENTID is null
exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;
update dbo.[MKTSEGMENTLIST] set
[CONSOLIDATEDQUERYVIEWID] = @CONSOLIDATEDQUERYVIEWCATALOGID,
[CHANGEDBYID] = @CHANGEAGENTID,
[DATECHANGED] = getdate()
where [ID] = @ID;
end try
begin catch
exec dbo.[USP_RAISE_ERROR];
return 1;
end catch
return 0;