UFN_MKTSEGMENTLIST_SHOWINQUERYDESIGNER

CREATE function dbo.[UFN_MKTSEGMENTLIST_SHOWINQUERYDESIGNER]
(
  @ID uniqueidentifier
)
returns bit
as
begin
  declare @STATUSCODE tinyint;
  declare @SEGMENTLISTID uniqueidentifier;

  select
    @STATUSCODE = [MKTSEGMENTLIST].[STATUSCODE],
    @SEGMENTLISTID = [MKTSEGMENTLIST].[ID]
  from dbo.[MKTSEGMENT]
  inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
  where [MKTSEGMENT].[ID] = @ID;

  if @STATUSCODE = 0  --Pending import

    --This is either a new segment or it is being reimported, so grab the previous import...

    select
      @SEGMENTLISTID = [ID]
    from dbo.[MKTSEGMENTLIST]
    where [SEGMENTID] = @ID
    and [ID] <> @SEGMENTLISTID
    order by [DATEADDED] asc;

  --See if the query view is hidden or not...

  return (select cast(isnull([QUERYVIEWCATALOG].[ROOTOBJECT], 0) as bit)
          from dbo.[MKTSEGMENTLIST]
          left join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTSEGMENTLIST].[QUERYVIEWCATALOGID]
          where [MKTSEGMENTLIST].[ID] = @SEGMENTLISTID);
end