UFN_MKTSEGMENTATION_GETMARKETINGPLANBRIEFCOUNT

Returns the number of marketing plan segments for a marketing effort.

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@SEGMENTATIONID	uniqueidentifier	IN

Definition

Copy



create function dbo.[UFN_MKTSEGMENTATION_GETMARKETINGPLANBRIEFCOUNT]
(
  @SEGMENTATIONID uniqueidentifier
)
returns int
as
begin
  return (
    select count(*)
    from dbo.[MKTMARKETINGPLANBRIEF]
    where [MARKETINGPLANITEMID] = (select [MARKETINGPLANITEMID]
                                   from dbo.[MKTSEGMENTATION]
                                   where [ID] = @SEGMENTATIONID)
  );
end;