none
Finding the distance between the origin and destination Zipcodes using SQL RRS feed

  • Question

  • Hi All,

    Hope you are doing well!....I am trying to find  the distance between the origin and the destination zip codes ..Can you please help me here...Please find the DDL below:

    create table #zip
    (originzip varchar(30),
    destinationzip varchar(30))

    insert into #zip values
    ('11235-5262','8638'),
    ('32714-4682','8810'),
    ('63031','76140'),
    ('85262-3135','89015'),
    ('75240-5654','8638'),
    ('93730-5151','98443'),
    ('47172-7801','91761'),
    ('92651-3471','95691'),
    ('11731-1623','8638'),
    ('95003-9613','91730'),
    ('12590','77047'),
    ('92122-1707','11735'),
    ('32812','92865'),
    ('77477','91761'),
    ('86001-5590','59930'),
    ('86001-5590','59930'),
    ('10901-7854','8638'),
    ('07302-2871','8817'),
    ('92657-1307','92865'),
    ('57252-5968','91789')

    Thanks,

    Arun


    Arun

    Thursday, October 10, 2019 6:55 AM

Answers

  • For this you need the geo coordinates for the ZIP codes to calculate the distance; just with only the ZIP's it's not possible.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    • Marked as answer by Hellothere8028 Thursday, October 10, 2019 9:49 AM
    Thursday, October 10, 2019 7:42 AM

All replies