To the OP:

is this meant to be a dynamic statement, or are you tables really of this format? Are all your tables named "t#" and your columns named...

At a guess, maybe because you have two sets of double quotes: ExecuteSql"(varchar(max),"USE MASTER. Thus the second one is closing your first; making your entire query un-encapsulated.

Duplicate of https://www.sqlservercentral.com/Forums/1901858/Unable-to-access-Reporting-services-reports-from-application. Please stick to one topic per discussion.

As stated in the other topic though, I think you're out of luck. Put your computer(s) in...

You say it provides "Wrong results", however, you have provided us any data to work with, or what you expect the right results to be. This'll be difficult to troubleshoot...

If the JOIN is still really slow, then I imagine your Indexes have been poorly chosen. Providing DDL with the indexes would help.

Why are joining onto Table B 3 times on the same value? You could return the same column 3 times with 1 JOIN, not use 3 to the same value...

I can't tell you a lot either I'm afraid. I do have it, and use it, but that was due to more necessity than choice; SSMS isn't available on Linux...

And we're done! Whoop whoop!

Surprisingly went smoothly, and didn't end as a midnighter. 😀

"Not working"? What do you mean? Does it return incorrect results? Error? (You didn't provide an error message though). Mayne your SQL Server falls over when you use your query?...