USP_SIMPLEDATALIST_EVENTPRICE

Returns a list of prices for a given fundraising event.

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN

Definition

Copy



            create procedure dbo.USP_SIMPLEDATALIST_EVENTPRICE
            (
                @EVENTID uniqueidentifier = null
            )
            as
            select 
                ID as VALUE, 
                NAME as LABEL
            from dbo.EVENTPRICE
            where EVENTID = @EVENTID
            order by NAME