How is the user trying to login into the SQL Server? It sounds like it's trying to pass the user as "joebloggsSQL@domainname.internal", and possibly even trying to use SQL Authentication,...

Ahh, I see what you're saying now: you worded your post easlier as if to say that LAG was returning multiple results, which it is not. You mean you want...

LAG isn't a command available in 2008, it was first brought in in 2012, so the above should have presented you with an error.

You'll need to JOIN back...

Are you really still using SQL Server 2000? That version hasn't been supported for over 4 years now. If you had a more recent version (2012+) you could easily achieve...

What are the errors you receive? We can't run your SQL and we don't have access to your data, server or environment, so I'm afraid only supplying your SQL doesn't...

The MT* tables will likely only have values for Branch 3 and 0 (or they should do!). 0 being the live branch and 3 being the test. If they're on...

Yes, you can. There are a lot of examples on the internet on how do so. I, myself, have to Google everytime I work with XML, as the syntax never...

You can install both SSMS 2016 and 2012 on the same machine, yes. Not sure why you would want to install an older version though, as SSMS 2017 is compatible...