USP_DATALIST_EVENTPROFILEREPORT_LOCATION

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

                    if @ISVISIBLE = 1
                    begin

                        declare @ISADMIN bit;
                        declare @APPUSER_IN_NONRACROLE bit;
                        declare @APPUSER_IN_NOSECGROUPROLE bit;

                        set @ISADMIN = dbo.UFN_APPUSER_ISSYSADMIN(@CURRENTAPPUSERID);
                        set @APPUSER_IN_NONRACROLE = dbo.UFN_SECURITY_APPUSER_IN_NONRACROLE(@CURRENTAPPUSERID);
                        set @APPUSER_IN_NOSECGROUPROLE = dbo.UFN_SECURITY_APPUSER_IN_NO_SECURITY_GROUP_ROLE(@CURRENTAPPUSERID);

                        select
                            LOCATION.NAME as LOCATIONNAME,
                            LOCATION.ADDRESSBLOCK as ADDRESS,
                            COUNTRY.DESCRIPTION as COUNTRY,
                            LOCATION.CITY,
                            STATE.DESCRIPTION as STATE,
                            LOCATION.POSTCODE,
                            LOCATION.PHONENUMBER,
                            NF.NAME as CONTACT,
                            (select EVENTLOCATIONROOM.NAME from dbo.EVENTLOCATIONROOM where EVENTLOCATIONROOM.ID = EVENT.EVENTLOCATIONROOMID) as LOCATIONROOMNAME
                        from 
                            dbo.EVENT
                        left join
                            dbo.CONSTITUENT on (EVENT.EVENTLOCATIONCONTACTID = CONSTITUENT.ID)
                                                and (@ISADMIN = 1 or 
                                                    @APPUSER_IN_NONRACROLE = 1 or
                                                    dbo.UFN_SECURITY_APPUSER_GRANTED_CONSTITID_FORREPORT(@CURRENTAPPUSERID, CONSTITUENT.ID, @APPUSER_IN_NOSECGROUPROLE) = 1)
                        left join
                            dbo.EVENTLOCATION LOCATION on EVENT.EVENTLOCATIONID = LOCATION.ID
                        left join
                            dbo.COUNTRY on LOCATION.COUNTRYID = COUNTRY.ID
                        left join
                            dbo.STATE on LOCATION.STATEID = STATE.ID
                        outer apply dbo.UFN_CONSTITUENT_DISPLAYNAME(CONSTITUENT.ID) NF    
                        where
                            (not EVENT.EVENTLOCATIONCONTACTID is null or not EVENT.EVENTLOCATIONID is null) and 
                            EVENT.ID = @EVENTID;
                    end