Cool! I'd suggest you test/consider a couple of tweaks. The first, in particular, may improve performance, while the second is (IMO at least!) easier to read:

INSERT INTO...

• This reply was modified 2 years, 4 months ago by Phil Parkin. Reason: Fix query

OK, so you're going from SQL Server to Excel. That means you can use a...

• This reply was modified 2 years, 4 months ago by Phil Parkin.

OK, simply change my final SELECT:

WITH CustomerGroup
AS (SELECT *
    FROM
    (
        VALUES
  ...

Something like this?

DROP TABLE IF EXISTS #Customer;

CREATE TABLE #Customer
(
    Name VARCHAR(50) NOT NULL
   ,CustomerNumber INT NOT NULL
);

INSERT #Customer
(
    Name
...

Well, Phil Parkin just because a word does not currently exist within any known dictionary does not mean it is not a viable word. In fact, Shakespeare is credited...

Then I cannot help, unfortunately.

Excuse my ignorance, but what is an EAP source?

No Jeff Moden I did not state that SQL was a dinosaur at all, I think I basically referred to others doing so with dynotopic languages such as Cobol....

Correct.

If 'SerialNumber' is unique per employee, I suggest you add it to the local database and put a clustered index on it.

To do the sync, create a staging table locally...

As you suggest that there will be many queries on the local database which reference data maintained on the remote database, my advice would be 'sync' for sure. The lack...

As this is a SQL Server forum, you won't find many code-first people here. We like to design our DBs first 🙂

As you suggest, it seems that a good solution...

They are different characters and therefore multiple nested REPLACE commands would be required.

DECLARE @x VARCHAR(50) = CONCAT ('Some''', CHAR (96), CHAR (145), CHAR (146));

SELECT @x
  ...

• This reply was modified 2 years, 4 months ago by Phil Parkin.

First of all, I have some suggestions for your existing query.

• To obtain a DATE from a DATETIME, simply use CAST(x as DATE). Try to avoid using number-to-character-to-number conversions, because...

As you already have the results in #temp, the query can be written as follows

WHERE contains(c.partitionKey, "BillingEncounter/17792") 
AND EXISTS (SELECT 1 FROM #temp t where t.EncounterId =...