Hi all,

the sample code posted ran fine, executed in one sec.

I've tried the cursor without the INSENSITIVE hint, no difference.

Following is the complete code, if anyone can see how to...

Hi, I'm not sure what CTE is?

Now, that is helpful information I can work with. Thanks.

yes, they are good for something.

Didn't get much out of your post

anyone know how to delete my own post? I've posted an updated version of it.

I've removed the transaction (although I should get it working with at some stage) and it all seems to work, the problem is, it hangs for about 3-4 minutes

Right at...

Thanks, but I was referring to: You can try increasing the digits of the inner ROUND function.

Hi again, can you provide a sample of what you mean? Thanks in advance.

You're a champ, it doesn't error anymore.

I gained a few kilometres but thats ok, maybe this calculation is more accurate?

Anyways, thanks a million for that.

Hi,

I expect it to calculate the distance between the two coordinates, which it does.

I could code something that will prevent the code form executing when both coordinates are the...

Hi,

thanks for your prompt response. I don't see the solution to the problem though? Would you happen to know it and be so kind to list it?