UFN_PROGRAMEVENT_GETPRICES

CREATE function dbo.UFN_PROGRAMEVENT_GETPRICES
(
    @EVENTID uniqueidentifier,
    @INCLUDEINACTIVE bit = 0
)
returns @PRICETYPES table
(
    PRICETYPECODEID uniqueidentifier not null,
    [DESCRIPTION] nvarchar(100) not null,
    FACEPRICE money not null,
    SEQUENCE int not null
)
as begin
    insert into @PRICETYPES
    select
        PRICETYPES.PRICETYPECODEID,
        PRICETYPES.[DESCRIPTION],
        PRICETYPES.FACEPRICE,
        PRICETYPES.SEQUENCE
    from dbo.[EVENT]
        cross apply dbo.UFN_PROGRAM_GETEVENTSANDPRICETYPES([EVENT].PROGRAMID, @INCLUDEINACTIVE) PRICETYPES
    where
        [EVENT].ID = @EVENTID
        and PRICETYPES.EVENTID = [EVENT].ID
        and (@INCLUDEINACTIVE = 1 or PRICETYPES.ISACTIVE = 1);

    return;
end