And I dont think its going to be fast with that many records - was really just hoping that there might be a faster way that I wasn't thinking...

Jeff

the query is the slow part of a larger process.its not being posted to a screen - query is part of universe of claims process that needs to look...

Hi Steve,

Thanks for getting back. I was given this table and figured out that this field a varchar(4000) was the field with the start and end dates times.  I...

According to your query, you're returning 22 million rows to the screen...

Question:  What makes you think that's going to be fast?  ...

That's great but without the book, the uncommented code you posted doesn't explain at all what the code is supposed to be teaching.

A serious word of caution on the use of PAGE compression...  If you're into doing any index maintenance, PAGE compression will nearly double the time and CPU it takes.  You...

It's just a select from 3 tables, and 2 of them are with left join. For aggregations, I would have done it on SQL Server side. Now I...

Is your "report" going to return all 600 Thousand "records" or is it going do some form of aggregation?

Heh... AI being "confidently incorrect"... Imagine that. 😛

To repeat the question that Phil asked but in different words....

You say something would "return error".  Please copy and post that error.

The following will do it without anything "fancy" that might not work in Oracle, which I've almost totally forgotten about.

   WITH
cteMinCustNbr AS
(--==== Calculate the minimum...

BWAAA-HAAA-HAAA!!! "IT DEPENDS".

https://en.wikipedia.org/wiki/Leap_second

I actually just realised PIVOT isn't working when Multiple rows are present  Putting a fake aggregation such as MAX isn't working as expected.

I'm stumped 🙁

Any ideas, to point me...

Same to you and yours, Steve.  And Merry Christmas to everyone.  This is a well deserved 4 day weekend for me.  Next weekend is, as well.

Update.  We migrated from 2016 Enterprise Edition to 2022 Enterprise Edition.  Virtually everything is run 30-40% slower.  I also did some simple tests between 2017 and 2022 on the same...