USP_DATALIST_EVENTSEATINGGROUPS

Returns a list of event groups to be used for event seating.

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_EVENTSEATINGGROUPS
                (
                    @EVENTID uniqueidentifier
                )
                as
                    set nocount on;

                    select 
                        EVENTGROUP.ID as [Event Group ID],
                        EVENTGROUPMEMBER.ID as [Event Group Member ID],
                        REGISTRANT.ID as [Registrant ID],
                        EVENTGROUP.NAME as [Group name],
                        dbo.UFN_REGISTRANT_GETNAME(REGISTRANT.ID) as [Registrant name],
                        EVENTGROUP.TSLONG
                    from 
                        dbo.EVENTGROUP
                        left join dbo.EVENTGROUPMEMBER on EVENTGROUPMEMBER.EVENTGROUPID = EVENTGROUP.ID
                        left join dbo.REGISTRANT on REGISTRANT.ID = EVENTGROUPMEMBER.REGISTRANTID and REGISTRANT.WILLNOTATTEND = 0
                    where 
                        EVENTGROUP.EVENTID = @EVENTID
                    order by
                        EVENTGROUP.NAME;