spEventItems

                CREATE procedure [dbo].[spEventItems]
                (
                    @ClientEventsID int
                )
                as
                    select    [ID], 
                            [ClientEventsID], 
                            [BackOfficeID], 
                            [LimitCapacity], 
                            [PageLink], 
                            [DisplayName], 
                            [DisplayDesc], 
                            [ShowRelations], 
                            [Attributes], 
                            [Target], 
                            [PageTabID],
                            [BaseCurrencyID],
                            [DisplayOrder],
                            [DocLinkID],
                            [MaxRegPerCheckout],
                            [SoldOutMessage]
                    from  dbo.EventItems
                    where [ClientEventsID] = @ClientEventsID
                    order by DisplayOrder