Edit: read the question wrong. 
Difficult to test without sample data.

Sure is: https://msdn.microsoft.com/en-us/library/ms179530.aspx

Select * FROM #a order by memberid, histclaim DESC

is that the order you require?

Yes, but each Windows and SQL cluster will require it's own shared disks, Names, IPs. 
IOW, you can use the same hardware to host 2 independently operating SQL clusters.

write a simple BCP script for the table you need to export, schedule as required.

Yes you can, but why would you keep SSMS 2014, any specific reason?

If it's in the same domain, it won't work, they need to be unique. 
Instead, stretch your Windows cluster over the 2 regions, so all nodes belong to the same...

No, personally I would not put anything other than the DB Engine on my production DB Server.
Give SSAS, SSIS, SSRS their own servers.

You'll need central storage, not dedicated to either.