USP_MKTSEGMENTLIST_GETFIELDSFORIMPORT

CREATE procedure dbo.[USP_MKTSEGMENTLIST_GETFIELDSFORIMPORT]
(
  @SEGMENTID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTSEGMENT].[NAME],
    [MKTSEGMENTLIST].[ID] as [SEGMENTLISTID],
    [MKTSEGMENTLIST].[LISTLAYOUTID],
    [MKTSEGMENTLIST].[QUERYVIEWCATALOGID],
    [MKTSEGMENTLIST].[STANDARDIDSETID],
    [MKTSEGMENTLIST].[DUPLICATEIDSETID],
    [MKTSEGMENTLIST].[MINIMUMDATAID],
    [MKTSEGMENTLIST].[MAXIMUMDATAID],
    dbo.[UFN_MKTSEGMENTLIST_MAKEVIEWNAME_FORQUERY]([MKTSEGMENTLIST].[ID]) as [VIEWNAMEFORQUERY],
    dbo.[UFN_MKTRECORDSOURCE_MAKEMATCHBACKTABLENAME]([MKTSEGMENT].[QUERYVIEWCATALOGID]) as [MATCHBACKTABLENAME],
    dbo.[UFN_MKTRECORDSOURCE_VALIDFORBBEC]([MKTSEGMENT].[QUERYVIEWCATALOGID]) as [RECORDSOURCEISBBEC],
    [MKTSEGMENTLIST].[IDSETRECORDTYPEID],
    isnull([RECORDTYPE].[NAME], '') as [IDSETRECORDTYPENAME],
    [MKTSEGMENT].[QUERYVIEWCATALOGID] as [RECORDSOURCEID]
  from dbo.[MKTSEGMENT]
  inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
  left outer join dbo.[RECORDTYPE] on [RECORDTYPE].[ID] = [MKTSEGMENTLIST].[IDSETRECORDTYPEID]
  where [MKTSEGMENT].[ID] = @SEGMENTID;

  return 0;