USP_MKTSEGMENTLIST_GETDEPENDENTSELECTIONSTOREFRESH

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

  select distinct
    [ADHOCQUERY].[ID] as [ADHOCQUERYID]
  from dbo.[ADHOCQUERY]
  inner join dbo.[IDSETREGISTERADHOCQUERY] on [IDSETREGISTERADHOCQUERY].[ADHOCQUERYID] = [ADHOCQUERY].[ID]
  inner join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [IDSETREGISTERADHOCQUERY].[IDSETREGISTERID]
  left join dbo.[MKTSEGMENTSELECTION] on [MKTSEGMENTSELECTION].[SELECTIONID] = [IDSETREGISTER].[ID]
  where [IDSETREGISTER].[RECORDTYPEID] = (
    select [IDSETREGISTER].[RECORDTYPEID]
    from dbo.[MKTSEGMENT]
    inner join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [MKTSEGMENT].[IDSETREGISTERID]
    where [MKTSEGMENT].[ID] = @SEGMENTID
  )
  and [IDSETREGISTER].[STATIC] = 1
  and [MKTSEGMENTSELECTION].[ID] is null;

  return 0;