USP_DATALIST_EVENTPRICES

Displays the registration options for the given event.
Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the data list.
Definition

Copy


                CREATE procedure dbo.USP_DATALIST_EVENTPRICES
                (
                    @EVENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select distinct 
                        EVENTPRICE.ID,
                        EVENTREGISTRATIONTYPE.DESCRIPTION,
                        EVENTPRICE.AMOUNT,
                        EVENTPRICE.RECEIPTAMOUNT,
                        EVENTPRICE.REGISTRATIONCOUNT,
                        dbo.UDA_BUILDLIST(BENEFIT.NAME) BENEFITLIST,
                        EVENTPRICE.NAME,
                        EVENT.BASECURRENCYID
                        --dbo.UFN_EVENTPRICEDESIGNATION_GETTOTALDESIGNATIONAMOUNT(EVENTPRICE.ID)

                    from 
                        dbo.EVENTPRICE
                        inner join dbo.EVENTREGISTRATIONTYPE on EVENTREGISTRATIONTYPE.ID = EVENTPRICE.EVENTREGISTRATIONTYPEID
                        inner join dbo.EVENT on EVENTPRICE.EVENTID = EVENT.ID
                        left join dbo.EVENTPRICEBENEFIT on EVENTPRICEBENEFIT.EVENTPRICEID = EVENTPRICE.ID
                        left join dbo.BENEFIT on EVENTPRICEBENEFIT.BENEFITID = BENEFIT.ID
                    where                         
                        EVENTID = @EVENTID                    
                    group by
                        EVENTPRICE.ID, EVENTREGISTRATIONTYPE.DESCRIPTION, EVENTPRICE.AMOUNT, EVENTPRICE.RECEIPTAMOUNT, EVENTPRICE.REGISTRATIONCOUNT, EVENTPRICE.NAME, EVENT.BASECURRENCYID
                    order by
                        EVENTREGISTRATIONTYPE.DESCRIPTION;