UPDATE t1
SET t1.col1 = ISNULL(t1.col1,UpdateValue)

I see no responses from Kevin.

Ken's query is a code fragment, as I assume is obvious...

Before I ask this question, I want to let you know that I followed the advice @Phil Parkins advice and first asked this question on an Oracle forum, however I...

There are some very clever people in this forum who will certainly come up with great ideas to help you. But here is my first attempt at speeding things up.

First,...

Can you show us the code for the function?

I dunt know if it's just me, but the notifications seem to be pretty slow. I'm seeing some 6-10 minutes after a post has been made or a modmail...

Almost identical to Mark"s solution

WITH groups
AS (SELECT t.TestType
          ,t.TestDate
         ...

One idea would be to have two tables, one main table and one which holds data temporarily.

Push all of the individual transactions to the second table.

Periodically (as frequently as you...

Will your function have any parameters?

Rather than posting links, which some people (including me) might choose not to open, can you post using text (for DDL and data) and images (showing desired results).

Hyperbole.

But, c'mon man,...

I think you need to ask this question in an Oracle forum, as it makes no sense to me.

In SQL Server terms, I think you'll agree that it's very clear:

"The...

Can you also post DDL and sample INSERT statements (if any) for tbl_probate_case?

50 feet? Is your browser set to Mr Magoo mode?

People will probably ask you to post execution plans (ideally for slow and fast executions) in order to be able to help you.

Here is that query again, in human-readable form: