UFN_TIXEVENT_GETLOCATIONS
Get the locations attached to a given event
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TIXEVENTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_TIXEVENT_GETLOCATIONS
(
@TIXEVENTID uniqueidentifier
) returns table
as
return
select
ID,
EVENTLOCATIONID
from
dbo.TIXEVENTLOCATION
where
TIXEVENTID = @TIXEVENTID