UFN_MKTSEGMENTATION_ISFROMMARKETINGPLAN
Returns whether or not the marketing effort is part of a marketing plan.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_MKTSEGMENTATION_ISFROMMARKETINGPLAN]
(
@SEGMENTATIONID uniqueidentifier
)
returns bit
as
begin
return (case when (select [MARKETINGPLANITEMID] from dbo.[MKTSEGMENTATION] where [ID] = @SEGMENTATIONID) is not null then 1 else 0 end);
end;