USP_DATALIST_MKTLISTLAYOUTLISTSEGMENTS

Displays all the list segments that use a specific layout.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.

Definition

Copy



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

  select
    [MKTSEGMENTLIST].[ID],
    [MKTSEGMENTLIST].[SEGMENTID],
    (case when [MKTSEGMENTLISTHISTORICAL].[ID] is null then [MKTSEGMENT].[NAME] else '    ' + [MKTSEGMENTLISTHISTORICAL].[SEGMENTNAME] end) as [NAME],
    (case when [MKTSEGMENTLISTHISTORICAL].[ID] is null then [MKTSEGMENT].[DESCRIPTION] else [MKTSEGMENTLISTHISTORICAL].[SEGMENTDESCRIPTION] end) as [DESCRIPTION],
    [MKTSEGMENTLIST].[STATUS],
    [MKTSEGMENTLIST].[STATUSCODE],
    (case when [MKTSEGMENTLISTHISTORICAL].[ID] is null then [MKTSEGMENTLIST].[DATECHANGED] else [MKTSEGMENTLISTHISTORICAL].[DATEADDED] end) as [DATEADDED]
  from dbo.[MKTSEGMENTLIST]
  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTLIST].[SEGMENTID]
  left join dbo.[MKTSEGMENTLISTHISTORICAL] on [MKTSEGMENTLISTHISTORICAL].[ID] = [MKTSEGMENTLIST].[ID]
  where [MKTSEGMENTLIST].[LISTLAYOUTID] = @ID
  order by [MKTSEGMENT].[NAME], [MKTSEGMENTLIST].[DATECHANGED] desc;

  return 0;