UFN_SELECTION_MKTSEGMENTATION_ACTIVEMAILINGS

Returns all marketing efforts that have been activated.

Return

Return Type
table

Definition

Copy



CREATE function dbo.[UFN_SELECTION_MKTSEGMENTATION_ACTIVEMAILINGS]()
returns table
as
  return
  (
    select [MKTSEGMENTATION].[ID]
    from dbo.[MKTSEGMENTATION]
    where [MKTSEGMENTATION].[ACTIVE] = 1
    and [MKTSEGMENTATION].[COMMUNICATIONTYPECODE] = 0
  );