UFN_MKTSEGMENTATION_HASCONSOLIDATEDVIEWSEGMENTS

Returns whether or not the marketing effort contains consolidated list view segments.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_MKTSEGMENTATION_HASCONSOLIDATEDVIEWSEGMENTS]
(
  @SEGMENTATIONID uniqueidentifier
)
returns bit
as
begin
  declare @HASCONSOLIDATEDLISTSEGMENTS bit;

  set @HASCONSOLIDATEDLISTSEGMENTS = 
    (case when exists(select *
                      from dbo.[MKTSEGMENTATIONSEGMENT]
                      inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
                      left join dbo.[IDSETREGISTER] on [IDSETREGISTER].[ID] = [MKTSEGMENT].[IDSETREGISTERID]
                      where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
                      and [IDSETREGISTER].[RECORDTYPEID] = (
                        select [QUERYVIEWCATALOG].[RECORDTYPEID]
                        from dbo.[MKTCONSOLIDATEDQUERYVIEWSPEC]
                        inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTCONSOLIDATEDQUERYVIEWSPEC].[CONSOLIDATEDQUERYVIEWCATALOGID]
                        where [MKTCONSOLIDATEDQUERYVIEWSPEC].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]))
      then 1 else 0 end);

  return @HASCONSOLIDATEDLISTSEGMENTS;
end