USP_MKTSEGMENTLIST_GETDEPENDENTSEGMENTSTOREFRESH

Returns a list of all dependent segments that use a selection from a given list segment.

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.[USP_MKTSEGMENTLIST_GETDEPENDENTSEGMENTSTOREFRESH]
(
  @SEGMENTID uniqueidentifier
)
as
  set nocount on;

  select
    [MKTSEGMENT].[ID] as [SEGMENTID],
    [MKTSEGMENTREFRESHPROCESS].[ID] as [SEGMENTREFRESHPROCESSID]
  from dbo.[MKTSEGMENT]
  inner join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [MKTSEGMENT].[IDSETREGISTERID]
  inner join dbo.[MKTSEGMENTREFRESHPROCESS] on [MKTSEGMENTREFRESHPROCESS].[SEGMENTID] = [MKTSEGMENT].[ID]
  where [MKTSEGMENT].[ID] <> @SEGMENTID
  and [IDSETREGISTER].[RECORDTYPEID] = (
    select [IDSETREGISTER].[RECORDTYPEID]
    from dbo.[MKTSEGMENT]
    inner join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [MKTSEGMENT].[IDSETREGISTERID]
    where [MKTSEGMENT].[ID] = @SEGMENTID
  );

  return 0;