UFN_SITEID_MAPFROM_SMARTFIELDID
Maps a smart field instance to a set of sites.
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SMARTFIELDID | uniqueidentifier | IN |
Definition
Copy
create function dbo.[UFN_SITEID_MAPFROM_SMARTFIELDID]
(
@SMARTFIELDID uniqueidentifier
)
returns table
as
return
(
select
[SMARTFIELDSITE].[SITEID]
from (select @SMARTFIELDID as [SMARTFIELDID]) as [T]
left join dbo.[SMARTFIELDSITE] on [SMARTFIELDSITE].[SMARTFIELDID] = [T].[SMARTFIELDID]
)