USP_DATALIST_PROSPECTRESEARCHREQUESTAPPUSERPERMISSIONS

                CREATE procedure dbo.USP_DATALIST_PROSPECTRESEARCHREQUESTAPPUSERPERMISSIONS
                as
                    set nocount on;

                    select
                        PRRAUP.[ID],
                        COALESCE(SUSER_SNAME(AU.USERSID),'') [USERNAME],
                        AU.[DISPLAYNAME],
                        PRRAUP.[CANVIEWREQUESTSASSIGNEDTOOTHERS]
                    from
                        dbo.[PROSPECTRESEARCHREQUESTAPPUSERPERMISSION] PRRAUP
                    left join
                        dbo.[APPUSER] AU on AU.[ID] = PRRAUP.[ID]
                    order by
                        [USERNAME] asc;