Technical Article

Zip Code Radius Search

Enter the starting zip code and the number of miles for a radius search and the SP will return all the zip codes within the number of miles specified.The data file can be found at http://www.census.gov/tiger/tms/gazetteer/zips.txtThe record layout van be found at http://www.census.gov/tiger/tms/gazetteer/zip90r.txt

2003-07-24

1,761 reads

Blogs

Daily Coping 23 May 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Cloud Formations – A New MVP Led Training Initiative

By

Hello, data friends! Let me spread a few words about the new MVP led...

Daily Coping 20 May 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

How to change datasource on multiple reports deployed to power bi report server

By olegserdia

Each query in power bi report has it's own connection string. If something wrong...

Call multiple packages based on result set of the query

By komal145

Hi, I have a query like "Select tablenumber from a table" Tablenumber 1 2...

LDF is not automatically shrinked with simple recovery mode

By mnemonicator

Hi there, we have SQL Server 2014 (Build - 12.0.6259.0) and my database have...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers