USP_SIMPLEDATALIST_MKTFINDERFILERECORDSOURCE
Returns a list of all recordsources for a vendor in a marketing effort.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN | Effort ID |
| @VENDORID | uniqueidentifier | IN | Vendor ID |
Definition
Copy
CREATE procedure dbo.USP_SIMPLEDATALIST_MKTFINDERFILERECORDSOURCE
(
@SEGMENTATIONID uniqueidentifier,
@VENDORID uniqueidentifier
)
as
set nocount on;
select distinct L.[RECORDSOURCEID] [VALUE], QV.[DISPLAYNAME] [LABEL]
from dbo.[MKTSEGMENTATIONSEGMENT] SS
inner join dbo.[MKTSEGMENT] S on S.[ID] = SS.[SEGMENTID]
inner join dbo.[MKTSEGMENTLIST] SL on SL.[ID] = S.[CURRENTSEGMENTLISTID] and SL.[TYPECODE] = 1
inner join dbo.[MKTLIST] L on L.[ID] = SL.[LISTID]
inner join dbo.[QUERYVIEWCATALOG] QV on QV.[ID] = L.[RECORDSOURCEID]
where SS.[SEGMENTATIONID] = @SEGMENTATIONID and L.[VENDORID] = @VENDORID;
return 0;