USP_SIMPLEDATALIST_EVENT_EVENTMANAGERS

A simple data list of an events managers and group members.
Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN
Definition

Copy


                CREATE procedure dbo.USP_SIMPLEDATALIST_EVENT_EVENTMANAGERS
                (
                    @EVENTID uniqueidentifier = null
                )
                as
                    set nocount on;

                    select VALUE, LABEL from 
                    (
                    select EVENTCOORDINATOR.CONSTITUENTID VALUE, CONSTITUENT_NF.NAME LABEL, CONSTITUENT_NF.NAME COORDINATOR
                    from EVENTCOORDINATOR
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTCOORDINATOR.CONSTITUENTID) CONSTITUENT_NF
                    where EVENTCOORDINATOR.EVENTID = @EVENTID    
                    union all
                    select GROUPMEMBER.MEMBERID VALUE, CONSTITUENT_NF.NAME LABEL, GROUPCONSTITUENT_NF.NAME COORDINATOR
                    from EVENTCOORDINATOR
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTCOORDINATOR.CONSTITUENTID) GROUPCONSTITUENT_NF
                    inner join dbo.GROUPMEMBER
                        on EVENTCOORDINATOR.CONSTITUENTID = GROUPMEMBER.GROUPID
                    cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(GROUPMEMBER.MEMBERID) CONSTITUENT_NF
                    where EVENTCOORDINATOR.EVENTID = @EVENTID
                        and dbo.UFN_GROUPMEMBER_ISCURRENTMEMBER(GROUPMEMBER.ID) = 1

                    ) c
                    order by COORDINATOR, LABEL;