USP_SIMPLEDATALIST_MKTFINDERFILEVENDOR
Returns a list of all vendors that have finder number reservations in a mailing.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SEGMENTATIONID | uniqueidentifier | IN | Mailing ID |
Definition
Copy
create procedure dbo.USP_SIMPLEDATALIST_MKTFINDERFILEVENDOR
(
@SEGMENTATIONID uniqueidentifier = null
)
as
set nocount on;
select distinct SFN.[VENDORID] [VALUE], C.[KEYNAME] [LABEL]
from dbo.[MKTSEGMENTATIONFINDERNUMBER] SFN
inner join dbo.[CONSTITUENT] C on C.[ID] = SFN.[VENDORID]
where SFN.[SEGMENTATIONID] = @SEGMENTATIONID or @SEGMENTATIONID is null;
return 0;