Possibly a dumb question, but if secondary should never become primary, do you even need AG to be set up? Could you set up something like replication instead?

As for having...

How is this (performance wise and for what you need):

DECLARE @Histo AS DATE;
SET @Histo = '1900-12-31';


;WITH Customers
AS
    (
      ...

• This reply was modified 1 years, 11 months ago by Mr. Brian Gale. Reason: converted tabs to spaces because the forum seems to hate tabs in code
• This reply was modified 1 years, 11 months ago by Mr. Brian Gale.

I am glad you got it optimized. One thing that MAY also help with your optimization is to change your UNION to a UNION ALL. That will remove an implicit...

• This reply was modified 1 years, 11 months ago by Mr. Brian Gale.

That is a long run time... so it sounds like it needs some optimizing.

How much data are you working with and where are you presenting the data? If it is...

For handling it dynamically, I imagine it would be possible, but dynamic SQL is always risky. Since this would be a "write once and never again" (hopefully), my opinion is...

There was some problems with your CTE's for the between_rows data due to the filter on RN=1. That shouldn't be applied on the between_rows set of data (happens higher up...

Feel free to ask. In my experience, I haven't needed to use the import functionality before. I've exported when I needed a data dump of all my reports to disk...

This looks like a homework or assignment or an interview question, so you will forgive me for not just spitting out a full TSQL query for this. What is always...

The best way I know how to do it then is to do an export to disk and then import it back in a new folder.

Here is the export script: