UFN_EVENTPRICE_GETBENEFITS

Returns all members for a given event price.

Return

Return Type
table

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTPRICEID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_EVENTPRICE_GETBENEFITS(
                @EVENTPRICEID uniqueidentifier
            )
            returns table
            as
            return (
                select
                    ID,
                    BENEFITID,
                    UNITVALUE,
                    QUANTITY,
                    TOTALVALUE,
                    DETAILS
                from
                    dbo.EVENTPRICEBENEFIT
                where
                    EVENTPRICEID = @EVENTPRICEID
            )