UFN_MKTSEGMENTATION_GETDISTINCTRECORDSOURCES
Returns a table containing the distinct record sources 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_GETDISTINCTRECORDSOURCES]
(
@SEGMENTATIONID uniqueidentifier
)
returns table
as
return (
select distinct
[MKTSEGMENT].[QUERYVIEWCATALOGID],
[QUERYVIEWCATALOG].[PRIMARYKEYTYPENAME]
from dbo.[MKTSEGMENTATIONSEGMENT]
inner join dbo.[MKTSEGMENT] on [MKTSEGMENT].[ID] = [MKTSEGMENTATIONSEGMENT].[SEGMENTID]
inner join dbo.[QUERYVIEWCATALOG] on [QUERYVIEWCATALOG].[ID] = [MKTSEGMENT].[QUERYVIEWCATALOGID]
where [MKTSEGMENTATIONSEGMENT].[SEGMENTATIONID] = @SEGMENTATIONID
);