USP_DATALIST_EVENTPROFILEREPORT_SPEAKER

                CREATE procedure dbo.USP_DATALIST_EVENTPROFILEREPORT_SPEAKER
                (
                    @EVENTID uniqueidentifier,
                    @ISVISIBLE bit = 1,
                    @CURRENTAPPUSERID uniqueidentifier
                )
                as
                    set nocount on;

                    if @ISVISIBLE = 1
                    begin
                        select
                            EVENTSPEAKER.CONSTITUENTID as CONSTITUENTID,
                            NF.NAME,
                            EVENTSPEAKER.TOPIC,
                            EVENTSPEAKER.SPEAKINGDATE,
                            dbo.UFN_HOURMINUTE_DISPLAYTIME(EVENTSPEAKER.SPEAKINGTIME) as SPEAKINGTIME,
                            case when EVENTSPEAKER.ISREGISTRANT = 1 then 'Yes' else 'No' end as ISREGISTRANT,
                            'http://www.blackbaud.com/CONSTITUENTID?CONSTITUENTID='+convert(nvarchar(36),EVENTSPEAKER.CONSTITUENTID) as CONSTITUENTLINK
                        from
                            dbo.EVENTSPEAKER
                            cross apply dbo.UFN_CONSTITUENT_DISPLAYNAME(EVENTSPEAKER.CONSTITUENTID) NF
                        where
                            EVENTSPEAKER.EVENTID = @EVENTID
                        order by
                            EVENTSPEAKER.SPEAKINGDATE, EVENTSPEAKER.SPEAKINGTIME, NF.NAME;
                    end