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,344 reads

Blogs

Viewing the Statistics Objects Used to Create an Execution Plan

By

Use trace flag 8666 to view the statistics objects that the optimizer used to...

A Biography Template for New Presenters

By

Presenting is difficult, and you already know that. It is also incredibly rewarding and...

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Read the latest Blogs

Forums

Problem with creating quri for alocating amount

By Deimos_farm

good day i came a cross of a problem So i have a quri...

Problem with Logic for new column

By kobinarashid

Hi guys, I have the following table DDL/DML CREATE TABLE #DailyOnHandForecast (Id INT, ItemNo_...

pivot on 2 fields

By Bruin

I'm trying to create a query that pivots on 2 fields(entity,channel) and produce a...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers