UFN_MKTSEGMENTATION_GETDISTINCTREVENUEQUERYVIEWCATALOGID
Returns a table containing the distinct revenue queryviewcatalog ID 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_GETDISTINCTREVENUEQUERYVIEWCATALOGID]
(
@SEGMENTATIONID uniqueidentifier
)
returns table
as
return (
select distinct [RS].[QUERYVIEWCATALOGID]
from dbo.[MKTGIFTRECORDSOURCE] [RS]
where [ID] in (select [QUERYVIEWCATALOGID] from dbo.[UFN_MKTSEGMENTATION_GETDISTINCTRECORDSOURCES](@SEGMENTATIONID))
);