So there's always exactly 1S and 1E record? And potentially many As?

If so, join table to itself with 1 side being S and another being E. Create a...

Sounds good. I don't know why I didn't think of that.

Thanks!

I have figured something out.

If I create the linked server manually and then run the procedure I get an explicitly raised error that I wrote in to tell me that...

The creation of the linked server does not fail. I copied the exact line of code and ran it separately on a SQL 2012 machine to create the linked...

It's not quite clear what you are after, but I'll take a stab at it. This would join the "starts" to the "ends" and allow for any "adjustments" in...