Have you taken collation into account?

Joe,

Why is it that you insist on unnecessary rules when highly performant alternatives are readily available?  If you can't apply all your high-falutin' principles to the task at...

Until we see that definition, there's very little we can do with it.  I still suspect you have a linked server issue that you may simply not know exists.   The...

There's a LOT of stuff going on in that view.   The execution plan shows the following for just a single FILTER operation, which appears to be doing a lot of...

Looks like an issue with some kind of password.   Have you Googled the error?

The query isn't likely to be the source of any grief here.   Your expression, however, is dependent on what report section that formula appears in, as well as what type...

That behavior depends on exactly how you go about it.  Since both of the dependent parameters are capable of being null, there's no good reason for the report to refresh...