UFN_SITEID_MAPFROM_MARKETINGVENDORCONTACTID
Maps a marketing vendor contact ID to a set of site IDs
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @MARKETINGVENDORCONTACTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SITEID_MAPFROM_MARKETINGVENDORCONTACTID
(
@MARKETINGVENDORCONTACTID uniqueidentifier
)
returns table
as
return
(
select CONSTITUENTSITE.SITEID
from
(select RECIPROCALCONSTITUENTID as CONSTITUENTID from dbo.RELATIONSHIP where ID = @MARKETINGVENDORCONTACTID) as T
left join dbo.CONSTITUENTSITE on CONSTITUENTSITE.CONSTITUENTID = T.CONSTITUENTID
)