thanks appreciate the hint!

Bringing a copy of the uuid over from the source to the destination and running the query on destination almost halved the time. Any further suggestions very welcome, thank you.

Hi, there are roughly the same number of rows in each table, about 1million. When I use locally it is very quick taking seconds, when running with the remote server...

Thanks for the reply. I tried it with MS Access as well using a pass through query and it worked fine. I think the trouble lies with the application. I...

I dont see any high CPU pressure on either.
What should I be looking for in the logs, if it just timesout then it doesnt appear in the logs...

Hi,
I am running from an EC2 instance  in Virginia.
Many Thanks

Thank you for the response, sorry for the confusion I am trying to write to JSON rather than read from it. I don't understand how this will help me.
Thanks

For example the direction is to use cross apply to replace the scalar functions.

Thank you for your answers and I appreciate fully it is hard to get a full picture of the situation from my post. The problem is I have many of...

Sorry Thom,

I have tested with a different dataset and it isnt returning correctly.

INSERT [dbo].[ATABLE] ([EVENT_ID], [EVENT_RANK], [MIN_AGE], [MAX_AGE]) VALUES (1205, 1, NULL, 55.00000000089)

GO

INSERT [dbo].[ATABLE] ([EVENT_ID], [EVENT_RANK], [MIN_AGE], [MAX_AGE]) VALUES (1205,...

Thanks Thom, I will run this through and check it out.

Will also need to check out the proceeding functions.

Many Thanks,

Oliver

Thank you Thom, I am very grateful.

I will try this with a larger dataset and see how it gets on.

I am curious you moved away from windowing to joining is...

Thank you for posting the table Thom and for your window function. I understand what you have done and I too get the correct results in a much more elegant...

Thank you for the replies.

The required result is:

I have written a while loop which seems to work but my word it is clunky.

DECLARE

@RANK_ID INT,

@MAX_RANK_ID INT,

@RUNNING_MIN_AGE FLOAT = NULL,

@RUNNING_MAX_AGE...

amended, sorry about that.

I am going to try a while loop as another option.

Thanks,

Oliver