USP_BBNC_GETEVENTPRICES

            CREATE procedure dbo.USP_BBNC_GETEVENTPRICES
            (
                @BBNCID int
            )
            as
                set nocount on;

                select
                    [EVENTPRICEMAP].ID [MAPID],
                    EVENTPRICE.NAME,
                    EVENTPRICE.AMOUNT,
                    EVENTPRICE.RECEIPTAMOUNT,
                    EVENTPRICE.REGISTRATIONCOUNT
                from
                    dbo.BBNCEVENTIDMAP as [EVENTMAP]
                    inner join dbo.EVENT on EVENT.ID = [EVENTMAP].EVENTID
                    inner join dbo.EVENTPRICE on EVENTPRICE.EVENTID = EVENT.ID
                    left join dbo.BBNCEVENTPRICEIDMAP as [EVENTPRICEMAP] on [EVENTPRICEMAP].EVENTPRICEID = EVENTPRICE.ID
                where
                    [EVENTMAP].ID = @BBNCID
                order by
                    EVENTPRICE.NAME;