There are tiny differences in the estimates, but the plan hash and the query hash are identical. To all intents & purposes, they're the same plans. I saw some implicit...

Are there additional joins in this query that could also be affecting the number of rows returning? It does sound like it's a bit of a mess. Best of luck...

No matter what, you have to query the database (unless you export the data), so there has to be either an AD login or SQL login that can run the...

All these calculations on columns

SUBSTRING(InvoiceNumberMapping, 2, 7) = 
 

Sorry, not the person to help you with that. My C# skills are rusty to the point of immobility. Pretty sure there's a programming forum. I'd post there. Someone will...

I like option 2 for a bunch of reasons. If there is flexibility in what is included/not included in a location, that means that those values are not dependent on...

Happy to help. I'm always around here on the forums, or you can go to my blog. I also post the occasional video.

One recommendation...

So, your question is, can you make the four columns a primary key on one of the tables and then make a foreign key on the other table, right? The...

You can, although overall that sounds like a poor design. Name and address in both tables could lead to duplicate data and all sorts of issues.

I'd rather...

Not to mention NOLOCK everywhere, SELECT *... This is just a series of common code anti-patterns.