Because we don't have a lot of detail, I'm guessing a tad wildly here, but try this and let me know what you get:
WITH MAX_DATES AS (

    SELECT...

Once again, you haven't fully described your problem, as we have no idea how the additional field relates back to the preceding records that it having a value is supposed...

Yes, but if the assembly requires the function, then you just have that part of the script "out of order".

You'll need to check exactly what Service Pack and CU you are currently at with that server.   If you're already beyond SP1, then it may be something else.   However, given...

I'm not sure why you're asking the question...    XACT_ABORT is designed around handling OLE_DB connections.   What have you experienced that makes you ask this question?

If the DBA wants to argue that having the linked server in one direction is OK and from the other, it's not, then get him to explain what's different about...

Is there some reason you need to run this on Server B ?   Why not just reverse the OPENQUERY and solve the problem from the other side of the house,...

First you should find out what the latest Service Pack is.   (I think it's SP3) and then download that and install it.   That will bring you to the level associated...

And perhaps more importantly, WHY are you needing to filter out certain values, and are you sure that you will always want to filter out such values?   Are there conditions,...

Okay, that provides the basic logic you're seeking to follow, but what you haven't described is the scope of the problem, meaning is this for a small fixed number of...