USP_MKTRECORDSOURCE_GETMARKETINGINFO

Returns information needed to create the marketing information query views.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.[USP_MKTRECORDSOURCE_GETMARKETINGINFO]
(
  @ID uniqueidentifier
)
as
  set nocount on;

  declare @MARKETINGINFOQUERYVIEWCATALOGID uniqueidentifier;

  if exists(select 1 from dbo.[MKTRECORDSOURCE] where [ID] = @ID)
    select
      @MARKETINGINFOQUERYVIEWCATALOGID = [MARKETINGINFOQUERYVIEWCATALOGID]
    from dbo.[MKTRECORDSOURCE]
    where [ID] = @ID;

  select
    @MARKETINGINFOQUERYVIEWCATALOGID as [MARKETINGINFOQUERYVIEWCATALOGID],
    dbo.[UFN_CONSTITUENTSEGMENT_MAKETABLENAME]([ID]) as [CONSTITUENTSEGMENTTABLENAME],
    [DISPLAYNAME] as [SOURCEVIEWDISPLAYNAME],
    [OBJECTNAME] as [PARENTVIEW],
    [PRIMARYKEYFIELD] as [PARENTVIEWRELATEDFIELD]
  from dbo.[QUERYVIEWCATALOG]
  where [ID] = @ID;

  return 0;