UFN_SITEID_MAPFROM_EVENTSEATINGID
Maps a EVENTSEATINGID to a SITEID
Return
Return Type |
---|
table |
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@EVENTSEATINGID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SITEID_MAPFROM_EVENTSEATINGID
(
@EVENTSEATINGID uniqueidentifier
)
returns table
as
return
select EVENTSITE.SITEID
from dbo.[EVENT]
left outer join dbo.EVENTSITE on EVENTSITE.EVENTID = [EVENT].ID
where EVENT.ID = @EVENTSEATINGID;