UFN_MKTSEGMENTATION_GETDISTINCTMEMBERSHIPQUERYVIEWCATALOGID
Returns a table containing the distinct membership query view catalog IDs for all segments in a marketing effort.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_MKTSEGMENTATION_GETDISTINCTMEMBERSHIPQUERYVIEWCATALOGID]
(
@SEGMENTATIONID uniqueidentifier
)
returns table
as
return (
select distinct [RS].[QUERYVIEWCATALOGID]
from dbo.[MKTMEMBERSHIPRECORDSOURCE] [RS]
where [ID] in (
-- record source for all standard or revenue segments
select [MKTSEGMENT].[QUERYVIEWCATALOGID]
from dbo.[MKTSEGMENTATIONSEGMENT]
inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
where [MKTSEGMENT].[SEGMENTTYPECODE] in (1, 3) --Standard or Revenue
and [MKTSEGMENT].[QUERYVIEWCATALOGID] not in (select [CONSOLIDATEDQUERYVIEWCATALOGID] from dbo.[MKTCONSOLIDATEDQUERYVIEWSPEC])
and [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
));