Hi Sean,

thanks for your reply and i tested all three scenarios and i don't see performance difference.

Hi Erik,

Here is my confusion, if i use the Sean's suggestion i am in the position to use the same query for two times as i need that output for...

thanks eric and in that case what i supposed to use? temp table?

Great and thanks for the confirmation that there is no performance impact on this query.

Hi Sean,

thanks for reply and if at all if there is any improvement on the query in which part of execution plan will intimate me. Any suggestion. Can i assume...

Thank you dude. Mind didn't work on this. appreciate your time

Hi Eirik,

finally adding spatial index on the geography column help me to speed up the process. am all set. Thanks for your knowledge sharing.

thank you dwain too.

Hi Eirik,

This is what i have tried from the thread you shared,

with GEO_DATA AS

(

SELECT

DG.Zipcode,

...

Wonderful, thanks eric your solution worked.

but, geography function takes time to respond. i have 50000 zipcode in my test table and used below query to get the result.

egin

DECLARE @geo1 geography

,...

Hi Dwain,

thanks and i tried to understand the geography data type and i am trying to add new column in my table with geography datatype.

alter table Zipcode add...

Yes i understand that. Even i tried the below on and produces distance in miles.

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...

Yes Dwain, Is the below one you are asking?

CREATE FUNCTION HaversineDistance

(@OriginLat FLOAT

,@OriginLong FLOAT

...

Hi Dwain,

thanks for your reply and i gone through link. Really it's very high level and am struggling how do i correlate that with my requirement. If possible could you...

Hi Nevyn,

thanks for your reply and am sorry that address is not part of my zipcode table. Basically, i need to search the shopping mall/stores based on zipcode. I have...

Thanks Eirik