USP_MKTSEGMENTLISTCONSOLIDATEDQUERYVIEW_UPDATERELATIONSHIPS

Executes the "Consolidated Query View: Update Relationships" 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_MKTSEGMENTLISTCONSOLIDATEDQUERYVIEW_UPDATERELATIONSHIPS]
(
  @ID uniqueidentifier, -- ignored

  @CHANGEAGENTID uniqueidentifier
)
as
  begin
    declare @RSQV nvarchar(128);
    declare @CVQV nvarchar(128);
    declare @CONSOLIDATEDQUERYVIEWCATALOGID uniqueidentifier;

    declare CONSOLIDATEDQUERYVIEWS cursor local fast_forward for
    select [RSQV].[OBJECTNAME], [CVQV].[OBJECTNAME], [MKTCONSOLIDATEDQUERYVIEWSPEC].[CONSOLIDATEDQUERYVIEWCATALOGID]
    from dbo.[MKTCONSOLIDATEDQUERYVIEWSPEC]
    inner join dbo.[QUERYVIEWCATALOG] as [RSQV] on [RSQV].[ID] = [MKTCONSOLIDATEDQUERYVIEWSPEC].[ID]
    inner join dbo.[QUERYVIEWCATALOG] as [CVQV] on [CVQV].[ID] = [MKTCONSOLIDATEDQUERYVIEWSPEC].[CONSOLIDATEDQUERYVIEWCATALOGID];

    open CONSOLIDATEDQUERYVIEWS;
    fetch next from CONSOLIDATEDQUERYVIEWS into @RSQV, @CVQV, @CONSOLIDATEDQUERYVIEWCATALOGID;

    while (@@FETCH_STATUS = 0)
      begin
        exec dbo.[USP_QUERYVIEW_CLONERELATIONSHIPS] @RSQV, @CVQV, @CONSOLIDATEDQUERYVIEWCATALOGID, @CHANGEAGENTID;

        fetch next from CONSOLIDATEDQUERYVIEWS into @RSQV, @CVQV, @CONSOLIDATEDQUERYVIEWCATALOGID;
      end

    close CONSOLIDATEDQUERYVIEWS;
    deallocate CONSOLIDATEDQUERYVIEWS;

    return 0;
  end