UFN_EVENTPRICELIST_GETEVENTPRICES

This function returns a event pricelist's event prices given its ID.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTPRICELISTID	uniqueidentifier	IN

Definition

Copy



        CREATE function dbo.UFN_EVENTPRICELIST_GETEVENTPRICES
    (
      @EVENTPRICELISTID uniqueidentifier
    )
        returns table
        as return
            select
                ID,
        PRICETYPECODEID,
        FACEPRICE
            from
                dbo.PROGRAMEVENTPRICE
            where
                EVENTPRICELISTID=@EVENTPRICELISTID;