Thank you - very helpful indeed!

Regards

Dave

Hi,

Got a bit sidetracked, but now back looking to smooth this out.

I am working on the larger area calculations and want to know if there is any way that i...

I didn't know this.

I will take a look - thanks again for your help.

Regards

Dave

Hi MickyT

Thank you for your message.

I agree that while we are looking at a smallish area, the curvature of the earth is not that relevant, however, I do want the...

It is easy when you know how!

Thank you very much - you have made my day.

Appreciate your help and hope you have a good rest of your day.

Regards

Dave

Lowell - thanks for your reply.

The set of Lat Lons that I have are already the lat lon incrementals, but starting with a point and then creating in SQL sounds...

And sorry for the poor spelling - appalling!

Thanks Dan.

This now gives me all accounts that have an effective date after todays date. I am trying to find all accounts that are live as at todays date. I.E....

Hi Dan,

Thanks for your quick reply.

I have amended my code as follows:

select *

from dbo.TvwContractView

where

BusinessUnit = 'Property_DATA_LIBRARY'

and Book = 'Property - Live'

and [Type] = 'Layer'

and GETDATE()

and [Status]...