What is missing here? What don't you see? What do you not understand about the lists? You've given some requirements (though not the results you expect given that data) and...

We are happy to help, but not do the work for you. What have you done?  There are some questions and notes in the post in the T-SQL forum.

Closing. Post here: https://www.sqlservercentral.com/Forums/2014438/Can-you-help-me-on-this

Closing: Post here: https://www.sqlservercentral.com/Forums/2014438/Can-you-help-me-on-this

Merry Christmas and Happy Holidays.  Everyone be safe and enjoy time with loved ones.

http://www.sqlservercentral.com/articles/T-SQL/71571/

with cmn as (
select
  a.a
from TableA a
inner join TableB b on a.a = b.a and a.b =...

Double check that the remote is running and listening on 1433. Check the errorlog.

The driver for connection is generic. 2014 should connect to 2016. Maybe try using the...

You might try grouping on the ID and ordering by the index, but as Thom noted, your description doesn't quite make sense.

Don't use GETDATE(), use SYSDATETIME(). It's the more modern function, though in practicality they work the same.

Second, I assume that if this fails, you don't really care as...

In terms of failover, you'd need to write scripting to ensure that an instance fails over if it detects the other instance has failed.

However, I'm not sure that...

Are these on the same machine? If not, you could have firewall issues. Even if they are, you might not be connecting with the same protocol, or the browser might...

You can set the alias in the first SELECT and it will work. Doesn't need to be in both.

I see both sides. If the data is moved/masked, not sure there is a reason not to keep this metadata. Developers need to know this for work, to handle requirements...

Glad you enjoyed it.