UFN_MKTSEGMENTATIONACTIVATE_HASUNIMPORTEDLIST

Returns whether or not a marketing effort's imported lists have been imported.

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.[UFN_MKTSEGMENTATIONACTIVATE_HASUNIMPORTEDLIST]
(
  @SEGMENTATIONID uniqueidentifier
)
returns bit
as begin
    return (select 
              case 
                when exists(
                  select 1
                  from dbo.[MKTSEGMENTATIONSEGMENT]
                  inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
                  inner join dbo.[MKTSEGMENTLIST] on [MKTSEGMENTLIST].[ID] = [MKTSEGMENT].[CURRENTSEGMENTLISTID]
                  inner join dbo.[MKTLIST] on [MKTLIST].[ID] = [MKTSEGMENTLIST].[LISTID]
                  where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
                  and [MKTSEGMENTLIST].[TYPECODE] = 1
                  and [MKTLIST].[VENDORID] is null
                  and [MKTSEGMENT].[ISHISTORICAL] = 0)
                then 1
                else 0
              end);
end