@Wecks ...

Getting back to the subject and with the understanding that I try to anticipate the proverbial "next question" from my users, here's what I'd do along with some documentation...

BTW and just to clarify, I'm damned impressed with what they've been able to get ChatGPT to do.  The technology behind all of that is mind boggling .  My biggest...

Ok... I'm playing with a copy of the Person.Person table from a copy of the Adventure Works database.  I created 3 "scratch" tables, one for each name column, and populated...

You can probably get a significant boost to performance by removing FORMAT and converting those JOINS to a single CROSS APPLY.

It appears you are looking up the anonymized user...

Heh... Ed... as Jeffrey Williams also recommended, my sincere and very friendly recommendation is that you stop using FORMAT.  It's 17 times slower that just about any other rabbit you...

You are at the edge of a cliff.  I strongly recommend you turn around and go another way.

Heh... I did that with the count 1 to a million thing.  IIRC, I posted that little gem that said the rCTE that it created (which I also told it...

Thanks for taking the time to do these experiments, Jonathan.

The reason it got the Zip right is because it's in quotes.  You also had to realize its mistakes...

And, in the process of making the primary key, it made yet another mistake (at least according to my personal standards).  If it's a #TempTable, then never name the PK...

Thanks for taking the time to do these experiments, Jonathan.

The reason it got the Zip right is because it's in quotes.  You also had to realize its mistakes on the...

Heh... where's "Clippy" when you need him?  I can just see him saying "It looks like your trying to design a table to hold CDRs (Call Detail Records).  Do you...

Then after you wrote this I thought I'd see what ChatGPT could do to create a table with the data:

So I pasted the table in the question...

Then after you wrote this I thought I'd see what ChatGPT could do to create a table with the data:

So I pasted the table in the question into ChatGPT...

Unless the "with the matching dates" is to be interpreted as a date range selection, in which case Jeff Moden's integer math would be needed to ensure that the...

@Wecks ,

We still need an answer to my questions about the required rounding. Thanks.

EDIT:  Never mind... forgot to refresh before posting this.