UFN_EVENT_GETONSALEINFO
Returns on-sale information for a given event
Return
| Return Type |
|---|
| table |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EVENTID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_EVENT_GETONSALEINFO
(
@EVENTID 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
EVENTID = @EVENTID