|
|
|
|
 Click here to copy the following block | declare @maxi int, @curri int
select @curri = 0, @maxi = max(id) from #zips
while (@curri < @maxi )
update #zips
set @curri = id, nearest = acos((sin(radians(lat1)) * sin(radians(lat2))) +
(cos(radians(lat1)) * cos(radians(lat2)) *
cos(radians(long1)-radians(long2)))) * 69 *
( 180 / PI())
where id <= @curri + 10000 |
|
|
|
|
|
|
Submitted By :
Nayan Patel
(Member Since : 5/26/2004 12:23:06 PM)
|
 |
|
|
Job Description :
He is the moderator of this site and currently working as an independent consultant. He works with VB.net/ASP.net, SQL Server and other MS technologies. He is MCSD.net, MCDBA and MCSE. In his free time he likes to watch funny movies and doing oil painting. |
|
View all (893) submissions by this author
(Birth Date : 7/14/1981 ) |
|
|