UFN_TIXEVENT_GETONSALEINFO
Returns on-sale information for a given event
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TIXEVENTID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_TIXEVENT_GETONSALEINFO
(
@TIXEVENTID uniqueidentifier
) returns table
as
return
select
EVENTSALESMETHOD.ID,
EVENTSALESMETHOD.SALESMETHODID,
EVENTSALESMETHOD.ONSALEDATE,
EVENTSALESMETHOD.ONSALETIME,
SALESMETHOD.SEQUENCE
from
dbo.EVENTSALESMETHOD
inner join dbo.SALESMETHOD on EVENTSALESMETHOD.SALESMETHODID = SALESMETHOD.ID
where
TIXEVENTID = @TIXEVENTID