UFN_MKTSEGMENTATION_GETREQUIREDANDSELECTEDSOLICITCODEEXCLUSIONS
Returns all required solicit codes along with the solicit codes selected for a particular marketing effort activate process.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONACTIVATEPROCESSID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENTATION_GETREQUIREDANDSELECTEDSOLICITCODEEXCLUSIONS]
(
@SEGMENTATIONACTIVATEPROCESSID uniqueidentifier
)
returns table
as
return
select
[ID],
[ID] as [SOLICITCODEID],
convert(bit, 1) as [REQUIRED]
from dbo.[SOLICITCODE]
where [EXCLUSIONCODE] = 2 -- required
and [ACTIVE] = 1
union all
select
[ID],
[SOLICITCODEID],
convert(bit, 0) as [REQUIRED]
from dbo.[UFN_BUSINESSPROCESSCOMMPREF_GETEXCLUSIONS](@SEGMENTATIONACTIVATEPROCESSID);