UFN_EVENT_GETEVENTPRICES

This function returns an event's prices given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_EVENT_GETEVENTPRICES
        (
          @EVENTID uniqueidentifier
        )
        returns table
        as return
            select
                PROGRAMEVENTPRICE.ID,
                PRICETYPECODEID,
                PROGRAMEVENTPRICE.FACEPRICE,
                PROGRAMEVENTPRICE.SEQUENCE
            from
                dbo.PROGRAMEVENTPRICE
            inner join dbo.PRICETYPECODE on PRICETYPECODE.ID = PROGRAMEVENTPRICE.PRICETYPECODEID
            where
                EVENTID=@EVENTID and
                PRICETYPECODE.ACTIVE = 1;