Without model and/or data, it's a bit difficult to give a definite answer.

But I think that this can be solved with Grouping on the  ClaimsOfficer/Claimtype.
And for the...

I did play around with the suggested functions.

Thanks for all your replies, they were usefull to me.
Ben

Hello,
Does this help, use the Lead function to see if the next row is a start row, then declare the actual row the end row.
If there is not...

As with the others:
A bit of overprocessing.
Maybe you should look at triggers to maintain the seconde database.

Maybe or maybe not usefull :
Use a view...

The uniquifier

While reading the uniquifier does not do a lot for efficiency. It is not part of the selection mechanism, it is not part of the ordering mechanismn....

Thanks,
Ben

Hello Paul,

Whenever COUNT(*) is used in the SELECT clause of a statement, it has the 'same value' if it is repeated. It is the count of number of...

Something around these lines, especially the second solution might help you on.
The second query is equivalent to the first query, but might help in 'chopping' up the query.

Sorry for Butting In, this is not my expertise and I do not have a solutions. My apologies for that.

What often happens is that huge amounts of data...