USP_MKTSEGMENTLISTIMPORTPROCESS_GETOPTIONS

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

  select
    [MKTSEGMENTLISTIMPORTPROCESS].[SEGMENTLISTID],
    [MKTSEGMENTLIST].[SEGMENTID],
    [MKTSEGMENTLIST].[LISTLAYOUTID],
    [MKTSEGMENTLIST].[TOTALRECORDCOUNT],
    [MKTSEGMENTLIST].[STATUSCODE],
    [MKTSEGMENTLISTDEDUPEPROCESS].[ID] as [DUPLICATEPROCESSID],
    cast((case when [MKTSEGMENTLIST].[CONSOLIDATEDQUERYVIEWID] is null then 0 else 1 end) as bit) as [ISCONSOLIDATED],
    [MKTSEGMENT].[QUERYVIEWCATALOGID] as [RECORDSOURCEID],
    [MKTLISTLAYOUT].[ADDNEWCODETABLEENTRIES]
  from dbo.[MKTSEGMENTLISTIMPORTPROCESS]
  inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENTLISTIMPORTPROCESS].[SEGMENTLISTID]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTLIST].[SEGMENTID]
  left join dbo.[MKTSEGMENTLISTDEDUPEPROCESS] on [MKTSEGMENTLISTDEDUPEPROCESS].[SEGMENTLISTID] = [MKTSEGMENTLIST].[ID]
  inner join dbo.[MKTLISTLAYOUT] on [MKTLISTLAYOUT].[ID] = [MKTSEGMENTLIST].[LISTLAYOUTID]
  where [MKTSEGMENTLISTIMPORTPROCESS].[ID] = @ID;

  return 0;