UFN_SITEID_MAPFROM_VENDORID
Maps a vendor ID to a set of site IDs
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @VENDORID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.[UFN_SITEID_MAPFROM_VENDORID]
(
@VENDORID uniqueidentifier
)
returns table
as
return
(
select
[CONSTITUENTSITE].[SITEID]
from (select @VENDORID as [CONSTITUENTID]) as [T]
left join dbo.[CONSTITUENTSITE] on [CONSTITUENTSITE].[CONSTITUENTID] = [T].[CONSTITUENTID]
)