USP_MKTCONSOLIDATEDQUERYVIEW_ADDBBECCONSTITUENTRELATEDVIEW

CREATE procedure dbo.[USP_MKTCONSOLIDATEDQUERYVIEW_ADDBBECCONSTITUENTRELATEDVIEW]
(
  @CONSOLIDATEDQUERYVIEWCATALOGID uniqueidentifier,
  @PATHALIAS nvarchar(100),
  @CHANGEAGENTID uniqueidentifier
)
as
  set nocount on;

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

    if not exists (select top 1 1 from dbo.[QUERYVIEWRELATIONSHIP] where [ROOTQUERYVIEWID] = @CONSOLIDATEDQUERYVIEWCATALOGID and [RELATEDQUERYVIEWID] = 'EE8A7483-C483-4214-9646-4BB62EC29AB7' and [PATHALIAS] = @PATHALIAS)
      insert into dbo.[QUERYVIEWRELATIONSHIP] (
        [ROOTQUERYVIEWID],
        [RELATEDQUERYVIEWID],
        [ADDEDBYQUERYVIEWID],
        [PATHALIAS],
        [ROOTCOLUMN],
        [RELATEDCOLUMN],
        [SEQUENCE],
        [JOINTYPE],
        [JOINPARAMETERS],
        [CARDINALITYTYPE],
        [DISPLAYALIAS],
        [OBSOLETE],
        [RESOURCEFILEASSEMBLYNAME],
        [RESOURCEFILECLASSNAME],
        [ADDEDBYID],
        [CHANGEDBYID]
      ) values (
        @CONSOLIDATEDQUERYVIEWCATALOGID,
        'EE8A7483-C483-4214-9646-4BB62EC29AB7',
        @CONSOLIDATEDQUERYVIEWCATALOGID,
        @PATHALIAS,
        'ID',
        'ID',
        2147483647,
        0,
        0,
        4, -- one to optional one

        @PATHALIAS,
        1, -- obsolete, so it's hidden

        '',
        '',
        @CHANGEAGENTID,
        @CHANGEAGENTID
      );
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;