You could try the SSIS fuzzy lookup

Please post ddl and sqlplans.

Please see this article http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

In that case, i would assume that the vast majority of you rows have a long or lat of null.

Doesnt really negate what i have said before

You need to make the query sargable, at present you are looking at EVERY row to decide if that "point" it required.

You need something more like this....

BTW , Havent got...

No you cant replace it but you can cut down on the amount of calls considerably.

As i said before , if you calculate the Geographic square based upon :

@varLatitude...

Have you considered the use of a calendar table ?

http://sqlserver2000.databases.aspfaq.com/why-should-i-consider-using-an-auxiliary-calendar-table.html

@rpatil,

I dont often pull people up , but that is very bad advice.

You ask if there is a better way ,yes there is. Craig mentioned the non-SARGability of such queries.

Read...

Can you provide us with some simpler code that we can execute that will demonstrate your problem with MAX ?

I think this page will help you ....

http://www.karaszi.com/SQLServer/info_datetime.asp

Are you using 2008 ?

Have you looked at the spatial functions.

I would imagine the 'worst' offender here is using the function HaversineDistanceKm as a SARG.

Making a calculate the min and...

Cool, thanks for the feedback.

Always nice to know that the problem got resolved.

No , since Sep28 matches on both rows , the update order is arbitrary.

A fairly cool (IMO) change ,superseding old articles, could be happening to SSC in the future.

Comments ??

http://www.sqlservercentral.com/Forums/Topic1047170-433-1.aspx

Or even a link to 'key' discussion points for new articles.

I would imagine the majority of browsers would not read the full discussion following an article publication.

If you need to know who modified some data (including deletions) then you really have to pro-actively monitor use CDC http://msdn.microsoft.com/en-us/library/bb522489.aspx (or similar).