This is worse than the original query and the suggestions which have been made have not been implemented.
Are you able to create a view or stored procedure on the server 192.168.3.201?
Edit: derogatory comment references the OP's second posted query, not Jack's excellent suggestions.
For fast, accurate and documented assistance in answering your questions, please read this article.
Understanding and using APPLY, (I) and (II) Paul White
Hidden RBAR: Triangular Joins / The "Numbers" or "Tally" Table: What it is and how it replaces a loop Jeff Moden