Sorry Jeff.

I have been working with open query trying to get the values I need for my Insert into Staging Table. The query I have is returning some of...

Both, actually.  Too much in the morning and too little in afternoon/evening, and...

Gosh, Bruin... how do you expect anyone to help with such little information?

I don't know about CyberArk but I would hope that getting a Password for an SQL Service Account couldn't actually be done in such an easy...

I don't know the data well enough to say with conviction, but there has to be some criteria that you could use in an open query, other than a join,...

Heh... I've been having issues with caffeine absorption lately. 😀

Guys... the OP doesn't know which domains contain a "B" ahead of time.  He was just explaining the desired results for the test data he provided.  Or, at least, that's...

Scratched the answer that was here... I didn't read the post correctly.

The source table has 2 billion but not all records are chosen since it does a lookup ql.Tag_ID = sd.tagid

Any example of a script to do it in batches...

Heh... you're the one touting the handle of "sqlguru".  You should be teaching us how you fixed the issue. 😀

If you want help with a performance issue, we need more...

I only did 8 1/2 in the Navy... Silent Service on...

Yeah... I just made that realization.  Like I said in my edit of my previous post, the low level alarms for caffeine have sounded. 😀

Have you tried running the queries with a hint to force the use of the legacy cardinality estimator?

Also... when you migrated the data to the new server, did indexes get...

LOL! Ok.

The LPKCX are Cranes. The date and times are the location of the cranes as indicated by the Lat/Long. Calculating the distance between the given LPKCX location and...

DROP TABLE IF EXISTS #T;

SELECT *
  INTO #T
  FROM (VALUES ('1A','E'),('1A','IR'),('1A','N'),('1A','SC'),('1A','SCIR'),
             ...