>>
>>CREATE FUNCTION [dbo].[CalculateDistance]
>> (@Longitude1 DECIMAL(8,5),
>> @Latitude1 DECIMAL(8,5),
>> @Longitude2 DECIMAL(8,5),
>> @Latitude2 DECIMAL(8,5))
>>RETURNS FLOAT
>>AS
>>BEGIN
>>DECLARE @Temp FLOAT
>>
>>SET @Temp = SIN(@Latitude1/57.2957795130823) * SIN(@Latitude2/57.2957795130823) +
>> COS(@Latitude1/57.2957795130823) * COS(@Latitude2/57.2957795130823) * COS(@Longitude2/57.2957795130823 - @Longitude1/57.2957795130823)
>>
>>IF @Temp > 1
>> SET @Temp = 1
>>ELSE IF @Temp < -1
>> SET @Temp = -1
>>
>>RETURN (3958.75586574 * ACOS(@Temp) )
>>
>>END
>
>I already have the method to calculate the distance between two coordinates. I am trying to find the proper SQL command to return the records matching a certain distance from a set of coordinates.
One more time - read the blog I gave you a reference a couple of times. It has all necessary methods listed including what you're looking for.
If it's not broken, fix it until it is.
My Blog