Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @t table (idx int identity(1,1), zip varchar(10), originlatitude float, originlongitude float)
- insert into @t (zip)
- SELECT '85206'
- UNION ALL SELECT '91942'
- UNION ALL SELECT '97365'
- UNION ALL SELECT '97220'
- --UNION ALL SELECT '63146'
- UNION ALL SELECT '95037'
- UNION ALL SELECT '73072'
- UNION ALL SELECT '73170'
- UNION ALL SELECT '44672'
- UNION ALL SELECT '60629'
- UNION ALL SELECT '60634'
- UNION ALL SELECT '46805'
- UNION ALL SELECT '53129'
- UNION ALL SELECT '60010'
- UNION ALL SELECT '60010'
- UNION ALL SELECT '60712'
- UNION ALL SELECT '60640'
- UNION ALL SELECT '98204'
- --UNION ALL SELECT '98264'
- UNION ALL SELECT '10469'
- UNION ALL SELECT '01876'
- UNION ALL SELECT '95831'
- UNION ALL SELECT '97215'
- UNION ALL SELECT '02891'
- UNION ALL SELECT '98103'
- UNION ALL SELECT '98685'
- UNION ALL SELECT '66212'
- UNION ALL SELECT '60014'
- UNION ALL SELECT '76137'
- UNION ALL SELECT '75069'
- UNION ALL SELECT '24014'
- UNION ALL SELECT '76132'
- /*UNION ALL SELECT '8527'
- UNION ALL SELECT '75032'
- UNION ALL SELECT '98042'
- UNION ALL SELECT '77382'
- UNION ALL SELECT '80014'
- UNION ALL SELECT '44120'
- UNION ALL SELECT '93010'
- UNION ALL SELECT '94132'
- UNION ALL SELECT '96749'
- UNION ALL SELECT '94903'
- UNION ALL SELECT '94587'
- UNION ALL SELECT '2360'
- UNION ALL SELECT '91104'
- UNION ALL SELECT '80232'
- UNION ALL SELECT '85213'
- UNION ALL SELECT '6119'
- UNION ALL SELECT '2026'
- UNION ALL SELECT '49506'
- UNION ALL SELECT '92120'
- UNION ALL SELECT '98104'
- UNION ALL SELECT '89434'
- UNION ALL SELECT '48025'
- UNION ALL SELECT '60007'
- UNION ALL SELECT '60134'
- UNION ALL SELECT '60137'
- UNION ALL SELECT '60429'
- UNION ALL SELECT '48152'
- UNION ALL SELECT '60062'
- UNION ALL SELECT '60463'
- UNION ALL SELECT '60473'
- UNION ALL SELECT '48312'
- UNION ALL SELECT '85206'
- UNION ALL SELECT '82414'
- UNION ALL SELECT '97402'
- UNION ALL SELECT '97402'
- UNION ALL SELECT '80231'
- UNION ALL SELECT '38655'
- UNION ALL SELECT '59701'
- UNION ALL SELECT '58701'
- UNION ALL SELECT '46514'
- UNION ALL SELECT '46342'
- UNION ALL SELECT '46350'
- UNION ALL SELECT '49120'
- UNION ALL SELECT '97478'
- UNION ALL SELECT '30518'
- UNION ALL SELECT '6033'
- UNION ALL SELECT '59401'
- UNION ALL SELECT '78550'
- UNION ALL SELECT '78550'
- UNION ALL SELECT '79106'
- UNION ALL SELECT '78374'
- UNION ALL SELECT '74011'
- UNION ALL SELECT '97355'
- UNION ALL SELECT '55316'
- UNION ALL SELECT '29732'
- UNION ALL SELECT '25311'
- UNION ALL SELECT '97132'
- UNION ALL SELECT '98902'
- UNION ALL SELECT '97030'
- UNION ALL SELECT '85015'
- UNION ALL SELECT '84770'
- UNION ALL SELECT '97071'
- UNION ALL SELECT '38016'
- UNION ALL SELECT '79416'
- UNION ALL SELECT '97756'
- UNION ALL SELECT '30043'
- UNION ALL SELECT '42001'
- UNION ALL SELECT '98926'
- UNION ALL SELECT '97524'
- UNION ALL SELECT '99324'
- UNION ALL SELECT '76021'
- UNION ALL SELECT '97601'
- UNION ALL SELECT '67502'
- UNION ALL SELECT '21211'
- UNION ALL SELECT '84720'
- UNION ALL SELECT '71303'
- UNION ALL SELECT '91801'
- UNION ALL SELECT '18102'
- UNION ALL SELECT '78233'
- UNION ALL SELECT '29621'
- UNION ALL SELECT '46530'
- UNION ALL SELECT '22203'
- UNION ALL SELECT '85306'
- UNION ALL SELECT '94536'
- UNION ALL SELECT '95242'
- UNION ALL SELECT '93311'
- UNION ALL SELECT '94526'
- UNION ALL SELECT '34461'
- UNION ALL SELECT '14221'
- UNION ALL SELECT '33782'
- UNION ALL SELECT '80904'
- UNION ALL SELECT '33763'
- UNION ALL SELECT '78749'
- UNION ALL SELECT '29607'
- UNION ALL SELECT '98007'
- UNION ALL SELECT '13219'
- UNION ALL SELECT '34232'
- UNION ALL SELECT '17815'
- UNION ALL SELECT '34134'
- UNION ALL SELECT '33472'
- UNION ALL SELECT '33435'
- UNION ALL SELECT '34209'
- UNION ALL SELECT '33511'
- UNION ALL SELECT '92821'
- UNION ALL SELECT '80906'
- UNION ALL SELECT '44130'
- UNION ALL SELECT '60527'
- UNION ALL SELECT '93012'
- UNION ALL SELECT '79936'
- UNION ALL SELECT '44256'
- UNION ALL SELECT '61802'
- UNION ALL SELECT '2703'
- UNION ALL SELECT '44708'
- UNION ALL SELECT '2601'
- UNION ALL SELECT '92008'
- UNION ALL SELECT '92130'
- UNION ALL SELECT '33618'
- UNION ALL SELECT '91206'
- UNION ALL SELECT '90603'
- UNION ALL SELECT '85718'
- UNION ALL SELECT '24018'
- UNION ALL SELECT '77090'
- UNION ALL SELECT '85224'
- UNION ALL SELECT '91311'
- UNION ALL SELECT '72223'
- UNION ALL SELECT '1923'
- UNION ALL SELECT '43230'
- UNION ALL SELECT '79925'
- UNION ALL SELECT '95621'
- UNION ALL SELECT '33759'
- UNION ALL SELECT '34207'
- UNION ALL SELECT '75093'
- UNION ALL SELECT '34233'
- UNION ALL SELECT '12110'
- UNION ALL SELECT '32822'
- UNION ALL SELECT '29526'
- UNION ALL SELECT '29642'
- UNION ALL SELECT '75023'
- UNION ALL SELECT '94806'
- UNION ALL SELECT '17050'
- UNION ALL SELECT '93446'
- UNION ALL SELECT '32837'
- UNION ALL SELECT '77065'
- UNION ALL SELECT '24541'
- UNION ALL SELECT '2747'
- UNION ALL SELECT '30030'
- UNION ALL SELECT '23238'
- UNION ALL SELECT '33442'
- UNION ALL SELECT '79912'
- UNION ALL SELECT '19904'
- UNION ALL SELECT '77706'
- UNION ALL SELECT '34698'
- UNION ALL SELECT '85206'
- UNION ALL SELECT '13066'
- UNION ALL SELECT '75605'
- UNION ALL SELECT '28211'
- UNION ALL SELECT '1501'
- UNION ALL SELECT '41017'
- UNION ALL SELECT '79424'
- UNION ALL SELECT '95602'
- UNION ALL SELECT '98225'
- UNION ALL SELECT '1702'
- UNION ALL SELECT '75234'
- UNION ALL SELECT '98003'
- UNION ALL SELECT '86001'
- UNION ALL SELECT '95630'
- UNION ALL SELECT '39402'
- UNION ALL SELECT '33907'
- UNION ALL SELECT '45324'
- UNION ALL SELECT '77546'
- UNION ALL SELECT '95204'
- UNION ALL SELECT '32607'
- UNION ALL SELECT '37066'
- UNION ALL SELECT '99362'
- UNION ALL SELECT '85233'
- UNION ALL SELECT '85310'
- UNION ALL SELECT '80228'
- UNION ALL SELECT '27455'
- UNION ALL SELECT '29615'
- UNION ALL SELECT '21742'
- UNION ALL SELECT '78229'
- UNION ALL SELECT '98569'
- UNION ALL SELECT '93906'
- UNION ALL SELECT '17110'
- UNION ALL SELECT '22801'
- UNION ALL SELECT '95662'
- UNION ALL SELECT '98837'
- UNION ALL SELECT '75654'
- UNION ALL SELECT '31909'
- UNION ALL SELECT '39047'
- UNION ALL SELECT '28791'
- UNION ALL SELECT '95376'
- UNION ALL SELECT '83201'
- UNION ALL SELECT '43050'
- UNION ALL SELECT '60169'
- UNION ALL SELECT '78232'
- UNION ALL SELECT '75061'
- UNION ALL SELECT '34957'
- UNION ALL SELECT '60431'
- UNION ALL SELECT '60431'
- UNION ALL SELECT '70065'
- UNION ALL SELECT '78240'
- UNION ALL SELECT '37660'
- UNION ALL SELECT '98033'
- UNION ALL SELECT '34653'
- UNION ALL SELECT '70508'
- UNION ALL SELECT '95758'
- UNION ALL SELECT '70605'
- UNION ALL SELECT '75238'
- UNION ALL SELECT '32746'
- UNION ALL SELECT '22192'
- UNION ALL SELECT '33805'
- UNION ALL SELECT '75228'
- UNION ALL SELECT '76308'
- UNION ALL SELECT '43125'
- UNION ALL SELECT '14750'
- UNION ALL SELECT '14420'
- UNION ALL SELECT '12804'
- UNION ALL SELECT '94541'
- UNION ALL SELECT '89120'
- UNION ALL SELECT '15650'
- UNION ALL SELECT '78209'
- UNION ALL SELECT '6790'
- UNION ALL SELECT '45040'
- UNION ALL SELECT '98037'
- UNION ALL SELECT '20109'
- UNION ALL SELECT '32257'
- UNION ALL SELECT '70471'
- UNION ALL SELECT '45750'
- UNION ALL SELECT '1863'
- UNION ALL SELECT '76708'
- UNION ALL SELECT '44256'
- UNION ALL SELECT '32901'
- UNION ALL SELECT '77042'
- UNION ALL SELECT '44060'
- UNION ALL SELECT '95348'
- UNION ALL SELECT '85213'
- UNION ALL SELECT '76904'
- UNION ALL SELECT '78727'
- UNION ALL SELECT '43701'
- UNION ALL SELECT '33618'
- UNION ALL SELECT '91325'
- UNION ALL SELECT '76021'
- UNION ALL SELECT '34711'
- UNION ALL SELECT '33803'
- UNION ALL SELECT '78218'
- UNION ALL SELECT '34471'
- UNION ALL SELECT '34481'
- UNION ALL SELECT '34761'
- UNION ALL SELECT '85016'
- UNION ALL SELECT '32073'
- UNION ALL SELECT '60467'
- UNION ALL SELECT '43081'
- UNION ALL SELECT '32765'
- UNION ALL SELECT '14870'
- UNION ALL SELECT '79902'
- UNION ALL SELECT '92262'
- UNION ALL SELECT '85710'
- UNION ALL SELECT '85382'
- UNION ALL SELECT '14450'
- UNION ALL SELECT '85032'
- UNION ALL SELECT '21208'
- UNION ALL SELECT '39402'
- UNION ALL SELECT '28792'
- UNION ALL SELECT '75703'
- UNION ALL SELECT '33782'
- UNION ALL SELECT '43123'
- UNION ALL SELECT '72211'
- UNION ALL SELECT '2360'
- UNION ALL SELECT '32127'
- UNION ALL SELECT '20854'
- UNION ALL SELECT '60070'
- UNION ALL SELECT '73120'
- UNION ALL SELECT '79413'
- UNION ALL SELECT '92270'
- UNION ALL SELECT '94534'
- UNION ALL SELECT '44266'
- UNION ALL SELECT '33063'
- UNION ALL SELECT '89509'
- UNION ALL SELECT '98057'
- UNION ALL SELECT '99352'
- UNION ALL SELECT '83202'
- UNION ALL SELECT '24153'
- UNION ALL SELECT '34223'
- UNION ALL SELECT '24015'
- UNION ALL SELECT '61112'
- UNION ALL SELECT '6067'
- UNION ALL SELECT '95661'
- UNION ALL SELECT '80231'
- UNION ALL SELECT '79705'
- UNION ALL SELECT '84102'
- UNION ALL SELECT '91773'
- UNION ALL SELECT '92675'
- UNION ALL SELECT '78666'
- UNION ALL SELECT '30350'
- UNION ALL SELECT '30350'
- UNION ALL SELECT '95403'
- UNION ALL SELECT '34231'
- UNION ALL SELECT '98204'
- UNION ALL SELECT '79121'
- UNION ALL SELECT '79762'
- UNION ALL SELECT '71105'
- UNION ALL SELECT '98208'
- UNION ALL SELECT '52404'
- UNION ALL SELECT '98383'
- UNION ALL SELECT '29307'
- UNION ALL SELECT '98290'
- UNION ALL SELECT '28209'
- UNION ALL SELECT '6074'
- UNION ALL SELECT '32216'
- UNION ALL SELECT '78759'
- UNION ALL SELECT '89147'
- UNION ALL SELECT '33351'
- UNION ALL SELECT '32086'
- UNION ALL SELECT '24401'
- UNION ALL SELECT '98003'
- UNION ALL SELECT '75238'
- UNION ALL SELECT '75070'
- UNION ALL SELECT '40272'
- UNION ALL SELECT '44224'
- UNION ALL SELECT '77478'
- UNION ALL SELECT '85375'
- UNION ALL SELECT '76109'
- UNION ALL SELECT '85749'
- UNION ALL SELECT '91356'
- UNION ALL SELECT '37814'
- UNION ALL SELECT '1876'
- UNION ALL SELECT '98374'
- UNION ALL SELECT '33907'
- UNION ALL SELECT '27530'
- UNION ALL SELECT '89523'
- UNION ALL SELECT '21212'
- UNION ALL SELECT '39056'
- UNION ALL SELECT '85741'
- UNION ALL SELECT '37388'
- UNION ALL SELECT '74105'
- UNION ALL SELECT '32708'
- UNION ALL SELECT '50322'
- UNION ALL SELECT '95687'
- UNION ALL SELECT '75206'
- UNION ALL SELECT '91762'
- UNION ALL SELECT '91789'
- UNION ALL SELECT '94558'
- UNION ALL SELECT '30339'
- UNION ALL SELECT '30080'
- UNION ALL SELECT '32703'
- UNION ALL SELECT '13090'
- UNION ALL SELECT '14626'
- UNION ALL SELECT '21157'
- UNION ALL SELECT '19713'
- UNION ALL SELECT '90602'
- UNION ALL SELECT '22407'
- UNION ALL SELECT '44094'
- UNION ALL SELECT '2026'
- UNION ALL SELECT '6525'
- UNION ALL SELECT '78240'
- UNION ALL SELECT '13850'
- UNION ALL SELECT '20716'
- UNION ALL SELECT '92886'
- UNION ALL SELECT '84404'
- UNION ALL SELECT '98902'
- UNION ALL SELECT '98683'
- UNION ALL SELECT '31210'
- UNION ALL SELECT '54914'
- UNION ALL SELECT '34238'
- UNION ALL SELECT '30263'
- UNION ALL SELECT '42071'
- UNION ALL SELECT '17870'
- UNION ALL SELECT '29615'
- UNION ALL SELECT '29926'
- UNION ALL SELECT '68434'
- UNION ALL SELECT '28791'
- UNION ALL SELECT '74464'
- UNION ALL SELECT '97838'
- UNION ALL SELECT '97361'
- UNION ALL SELECT '97128'
- UNION ALL SELECT '76180'
- UNION ALL SELECT '59808'
- UNION ALL SELECT '83501'
- UNION ALL SELECT '88201'
- UNION ALL SELECT '30643'
- UNION ALL SELECT '30518'
- UNION ALL SELECT '97383'
- UNION ALL SELECT '96080'
- UNION ALL SELECT '29505'
- UNION ALL SELECT '37064'
- UNION ALL SELECT '53704'
- UNION ALL SELECT '29169'
- UNION ALL SELECT '67901'
- UNION ALL SELECT '39531'
- UNION ALL SELECT '83815'
- UNION ALL SELECT '74403'
- UNION ALL SELECT '73120'
- UNION ALL SELECT '97470'
- UNION ALL SELECT '26330'
- UNION ALL SELECT '97914'
- UNION ALL SELECT '96097'
- UNION ALL SELECT '75230'
- UNION ALL SELECT '55345'
- UNION ALL SELECT '20164'
- UNION ALL SELECT '98370'
- UNION ALL SELECT '98837'
- UNION ALL SELECT '6033'
- UNION ALL SELECT '97520'
- UNION ALL SELECT '97138'
- UNION ALL SELECT '51104'
- UNION ALL SELECT '68845'
- UNION ALL SELECT '63376'
- UNION ALL SELECT '54482'
- UNION ALL SELECT '14127'
- UNION ALL SELECT '95422'
- UNION ALL SELECT '97128'
- UNION ALL SELECT '97219'
- UNION ALL SELECT '29926'
- UNION ALL SELECT '29926'
- UNION ALL SELECT '85028'
- UNION ALL SELECT '68850'
- UNION ALL SELECT '97223'
- UNION ALL SELECT '99223'
- UNION ALL SELECT '30529'
- UNION ALL SELECT '78028'
- UNION ALL SELECT '99354'
- UNION ALL SELECT '37664'
- UNION ALL SELECT '39157'
- UNION ALL SELECT '97303'
- UNION ALL SELECT '97062'
- UNION ALL SELECT '38119'
- UNION ALL SELECT '97056'
- UNION ALL SELECT '77062'
- UNION ALL SELECT '87124'
- UNION ALL SELECT '97202'
- UNION ALL SELECT '95540'
- UNION ALL SELECT '39305'
- UNION ALL SELECT '29732'
- UNION ALL SELECT '75023'
- UNION ALL SELECT '98028'
- UNION ALL SELECT '97527'
- UNION ALL SELECT '30064'
- UNION ALL SELECT '97527'
- UNION ALL SELECT '97527'
- UNION ALL SELECT '59715'
- UNION ALL SELECT '73120'
- UNION ALL SELECT '30087'
- UNION ALL SELECT '98662'
- UNION ALL SELECT '82801'
- UNION ALL SELECT '83703'
- UNION ALL SELECT '48116'
- UNION ALL SELECT '81401'
- UNION ALL SELECT '85032'
- UNION ALL SELECT '30122'
- UNION ALL SELECT '37075'
- UNION ALL SELECT '30188'
- UNION ALL SELECT '28117'
- UNION ALL SELECT '87111'
- UNION ALL SELECT '80917'
- UNION ALL SELECT '80236'
- UNION ALL SELECT '66210'
- UNION ALL SELECT '37830'
- UNION ALL SELECT '67010'
- UNION ALL SELECT '26330'
- UNION ALL SELECT '68787'
- UNION ALL SELECT '95661'
- UNION ALL SELECT '86303'
- UNION ALL SELECT '89108'
- UNION ALL SELECT '30114'
- UNION ALL SELECT '37221'
- UNION ALL SELECT '75092'
- UNION ALL SELECT '72034'
- UNION ALL SELECT '88201'
- UNION ALL SELECT '46815'
- UNION ALL SELECT '46227'
- UNION ALL SELECT '53214'
- UNION ALL SELECT '72801'
- UNION ALL SELECT '72903'
- UNION ALL SELECT '69001'
- UNION ALL SELECT '97070'
- UNION ALL SELECT '97478'
- UNION ALL SELECT '30188'
- UNION ALL SELECT '20906'
- UNION ALL SELECT '22032'
- UNION ALL SELECT '77401'
- UNION ALL SELECT '37027'
- UNION ALL SELECT '30324'
- UNION ALL SELECT '28210'
- UNION ALL SELECT '21045'
- UNION ALL SELECT '30338'
- UNION ALL SELECT '8820'
- UNION ALL SELECT '7932'
- UNION ALL SELECT '20815'
- UNION ALL SELECT '27410'
- UNION ALL SELECT '7748'
- UNION ALL SELECT '7092'
- UNION ALL SELECT '48170'
- UNION ALL SELECT '68114'
- UNION ALL SELECT '34952'
- UNION ALL SELECT '66208'
- UNION ALL SELECT '27612'
- UNION ALL SELECT '7458'
- UNION ALL SELECT '85251'
- UNION ALL SELECT '60174'
- UNION ALL SELECT '60174'
- UNION ALL SELECT '6902'
- UNION ALL SELECT '85373'
- UNION ALL SELECT '33618'
- UNION ALL SELECT '20852'
- UNION ALL SELECT '23455'
- UNION ALL SELECT '45459'
- UNION ALL SELECT '7052'
- UNION ALL SELECT '44145'
- UNION ALL SELECT '60187'
- UNION ALL SELECT '27106'
- UNION ALL SELECT '33901'
- UNION ALL SELECT '60005'
- UNION ALL SELECT '30350'
- UNION ALL SELECT '4043'
- UNION ALL SELECT '20814'
- UNION ALL SELECT '55116'
- UNION ALL SELECT '55113'
- UNION ALL SELECT '33433'
- UNION ALL SELECT '34684'
- UNION ALL SELECT '91730'
- UNION ALL SELECT '22205'
- UNION ALL SELECT '23235'
- UNION ALL SELECT '91910'
- UNION ALL SELECT '30319'
- UNION ALL SELECT '92507'
- UNION ALL SELECT '80246'
- UNION ALL SELECT '20165'
- UNION ALL SELECT '30062'
- UNION ALL SELECT '30047'
- UNION ALL SELECT '10552'
- UNION ALL SELECT '20817'
- UNION ALL SELECT '1960'
- UNION ALL SELECT '19063'
- UNION ALL SELECT '84117'
- UNION ALL SELECT '30350'
- UNION ALL SELECT '92011'
- UNION ALL SELECT '19067'
- UNION ALL SELECT '11234'
- UNION ALL SELECT '20886'
- UNION ALL SELECT '22306'
- UNION ALL SELECT '48334'
- UNION ALL SELECT '27609'
- UNION ALL SELECT '80121'
- UNION ALL SELECT '44134'
- UNION ALL SELECT '80236'
- UNION ALL SELECT '16507'
- UNION ALL SELECT '20190'
- UNION ALL SELECT '85718'
- UNION ALL SELECT '91775'
- UNION ALL SELECT '11235'
- UNION ALL SELECT '70810'
- UNION ALL SELECT '91355'
- UNION ALL SELECT '92705'
- UNION ALL SELECT '80918'
- UNION ALL SELECT '30045'
- UNION ALL SELECT '7004'
- UNION ALL SELECT '93065'
- UNION ALL SELECT '92886'
- UNION ALL SELECT '19001'
- UNION ALL SELECT '22304'
- UNION ALL SELECT '21401'
- UNION ALL SELECT '2476'
- UNION ALL SELECT '22207'
- UNION ALL SELECT '60010'
- UNION ALL SELECT '7920'
- UNION ALL SELECT '70809'
- UNION ALL SELECT '98008'
- UNION ALL SELECT '94002'
- UNION ALL SELECT '90210'
- UNION ALL SELECT '43209'
- UNION ALL SELECT '48302'
- UNION ALL SELECT '48301'
- UNION ALL SELECT '60108'
- UNION ALL SELECT '19422'
- UNION ALL SELECT '80301'
- UNION ALL SELECT '2184'
- UNION ALL SELECT '55313'
- UNION ALL SELECT '55313'
- UNION ALL SELECT '60089'
- UNION ALL SELECT '1803'
- UNION ALL SELECT '95608'
- UNION ALL SELECT '27513'
- UNION ALL SELECT '49546'
- UNION ALL SELECT '85226'
- UNION ALL SELECT '63017'
- UNION ALL SELECT '77450'
- UNION ALL SELECT '91711'
- UNION ALL SELECT '2025'
- UNION ALL SELECT '21044'
- UNION ALL SELECT '16046'
- UNION ALL SELECT '7626'
- UNION ALL SELECT '10710'
- UNION ALL SELECT '60014'
- UNION ALL SELECT '44223'
- UNION ALL SELECT '94526'
- UNION ALL SELECT '30030'
- UNION ALL SELECT '63131'
- UNION ALL SELECT '11746'
- UNION ALL SELECT '19025'
- UNION ALL SELECT '8816'
- UNION ALL SELECT '11554'
- UNION ALL SELECT '11733'
- UNION ALL SELECT '7020'
- UNION ALL SELECT '55435'
- UNION ALL SELECT '98020'
- UNION ALL SELECT '19341'
- UNION ALL SELECT '22033'
- UNION ALL SELECT '95628'
- UNION ALL SELECT '22031'
- UNION ALL SELECT '22046'
- UNION ALL SELECT '45840'
- UNION ALL SELECT '60422'
- UNION ALL SELECT '76132'
- UNION ALL SELECT '60148'
- UNION ALL SELECT '15024'
- UNION ALL SELECT '21702'
- UNION ALL SELECT '93720'
- UNION ALL SELECT '75034'
- UNION ALL SELECT '92835'
- UNION ALL SELECT '43230'
- UNION ALL SELECT '8205'
- UNION ALL SELECT '22030'
- UNION ALL SELECT '85296'
- UNION ALL SELECT '11542'
- UNION ALL SELECT '60137'
- UNION ALL SELECT '55422'
- UNION ALL SELECT '20016'
- UNION ALL SELECT '48236'
- UNION ALL SELECT '60031'
- UNION ALL SELECT '70403'
- UNION ALL SELECT '19041'
- UNION ALL SELECT '89012'
- UNION ALL SELECT '90254'
- UNION ALL SELECT '60035'
- UNION ALL SELECT '75240'
- UNION ALL SELECT '11741'
- UNION ALL SELECT '22124'
- UNION ALL SELECT '92648'
- UNION ALL SELECT '30022'
- UNION ALL SELECT '8527'
- UNION ALL SELECT '32256'
- UNION ALL SELECT '30097'
- UNION ALL SELECT '92109'
- UNION ALL SELECT '90623'
- UNION ALL SELECT '19444'
- UNION ALL SELECT '66211'
- UNION ALL SELECT '20176'
- UNION ALL SELECT '66215'
- UNION ALL SELECT '1453'
- UNION ALL SELECT '60614'
- UNION ALL SELECT '7738'
- UNION ALL SELECT '40222'
- UNION ALL SELECT '1940'
- UNION ALL SELECT '7940'
- UNION ALL SELECT '7746'
- UNION ALL SELECT '15237'
- UNION ALL SELECT '22102'
- UNION ALL SELECT '98040'
- UNION ALL SELECT '70002'
- UNION ALL SELECT '55345'
- UNION ALL SELECT '92691'
- UNION ALL SELECT '93940'
- UNION ALL SELECT '7950'
- UNION ALL SELECT '60540'
- UNION ALL SELECT '60563'
- UNION ALL SELECT '10956'
- UNION ALL SELECT '19073'
- UNION ALL SELECT '11563'
- UNION ALL SELECT '48170'
- UNION ALL SELECT '2062'
- UNION ALL SELECT '94619'
- UNION ALL SELECT '7675'
- UNION ALL SELECT '66221'
- UNION ALL SELECT '90272'
- UNION ALL SELECT '94306'
- UNION ALL SELECT '60464'
- UNION ALL SELECT '19355'
- UNION ALL SELECT '7652'
- UNION ALL SELECT '60068'
- UNION ALL SELECT '94954'
- UNION ALL SELECT '21208'
- UNION ALL SELECT '11803'
- UNION ALL SELECT '75093'
- UNION ALL SELECT '90094'
- UNION ALL SELECT '44514'
- UNION ALL SELECT '27612'
- UNION ALL SELECT '7869'
- UNION ALL SELECT '23229'
- UNION ALL SELECT '48307'
- UNION ALL SELECT '55901'
- UNION ALL SELECT '95677'
- UNION ALL SELECT '20850'
- UNION ALL SELECT '44116'
- UNION ALL SELECT '55113'
- UNION ALL SELECT '95825'
- UNION ALL SELECT '94402'
- UNION ALL SELECT '84093'
- UNION ALL SELECT '90404'
- UNION ALL SELECT '60173'
- UNION ALL SELECT '85258'
- UNION ALL SELECT '90740'
- UNION ALL SELECT '21146'
- UNION ALL SELECT '48315'
- UNION ALL SELECT '20904'
- UNION ALL SELECT '70461'
- UNION ALL SELECT '11788'
- UNION ALL SELECT '22150'
- UNION ALL SELECT '6905'
- UNION ALL SELECT '10304'
- UNION ALL SELECT '91604'
- UNION ALL SELECT '94087'
- UNION ALL SELECT '48098'
- UNION ALL SELECT '15241'
- UNION ALL SELECT '7719'
- UNION ALL SELECT '94598'
- UNION ALL SELECT '1778'
- UNION ALL SELECT '7470'
- UNION ALL SELECT '11704'
- UNION ALL SELECT '48323'
- UNION ALL SELECT '91304'
- UNION ALL SELECT '7090'
- UNION ALL SELECT '91361'
- UNION ALL SELECT '80020'
- UNION ALL SELECT '2493'
- UNION ALL SELECT '19382'
- UNION ALL SELECT '60527'
- UNION ALL SELECT '60091'
- UNION ALL SELECT '19803'
- UNION ALL SELECT '7677'
- UNION ALL SELECT '91364'
- UNION ALL SELECT '43085'
- UNION ALL SELECT '63117'
- UNION ALL SELECT '20008'
- UNION ALL SELECT '46032'
- UNION ALL SELECT '28226'
- UNION ALL SELECT '43221'
- UNION ALL SELECT '48236'
- UNION ALL SELECT '48105'
- UNION ALL SELECT '94109'
- UNION ALL SELECT '22901'
- UNION ALL SELECT '22060'
- UNION ALL SELECT '95014'
- UNION ALL SELECT '8004'
- UNION ALL SELECT '92211'
- UNION ALL SELECT '33442'
- UNION ALL SELECT '22203'
- UNION ALL SELECT '19041'
- UNION ALL SELECT '94401'
- UNION ALL SELECT '80021'
- UNION ALL SELECT '92653'
- UNION ALL SELECT '94301'
- UNION ALL SELECT '85032'
- UNION ALL SELECT '85382'
- UNION ALL SELECT '85712'
- UNION ALL SELECT '75081'
- UNION ALL SELECT '98040'
- UNION ALL SELECT '98125'
- UNION ALL SELECT '98133'
- UNION ALL SELECT '98115'
- UNION ALL SELECT '98004'
- UNION ALL SELECT '98178'
- UNION ALL SELECT '98029'
- UNION ALL SELECT '98103'
- UNION ALL SELECT '91302'
- UNION ALL SELECT '92024'
- UNION ALL SELECT '75093'
- UNION ALL SELECT '85260'
- UNION ALL SELECT '91801'
- UNION ALL SELECT '77382'
- UNION ALL SELECT '92780'
- UNION ALL SELECT '75063'
- UNION ALL SELECT '84117'
- UNION ALL SELECT '90277'
- UNION ALL SELECT '94002'
- UNION ALL SELECT '90048'
- UNION ALL SELECT '77070'
- UNION ALL SELECT '92675'
- UNION ALL SELECT '92026'
- UNION ALL SELECT '77339'
- UNION ALL SELECT '92627'
- UNION ALL SELECT '77478'
- UNION ALL SELECT '75219'
- UNION ALL SELECT '91702'
- UNION ALL SELECT '97233'
- UNION ALL SELECT '92509'
- UNION ALL SELECT '92307'
- */
- update @t
- set originlatitude = Radians(z.Zipcode_Latitude), originlongitude = Radians(z.Zipcode_Longitude)
- from @t t
- inner join v_Zipcodes z on t.zip = z.zipcode
- SELECT
- distinct z.Zip
- , t.zip as OriginZip
- , T.originlatitude
- , T.originlongitude
- , ROUND((ACOS((SIN(Radians(z.Lat)) * SIN(t.OriginLatitude)) + (COS(Radians(z.Lat)) * COS(t.OriginLatitude) * COS(t.OriginLongitude - Radians(z.Lng))))) * 3963,1) as Distance
- FROM Zip z, @t t
- WHERE
- ROUND((ACOS((SIN(Radians(z.Lat)) * SIN(t.OriginLatitude)) + (COS(Radians(z.Lat)) * COS(t.OriginLatitude) * COS(t.OriginLongitude - Radians(z.Lng))))) * 3963,1) < 10--@Radius
- ORDER BY originzip, Distance ASC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement