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 record layout van be found at


1,344 reads


Viewing the Statistics Objects Used to Create an Execution Plan


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

A Biography Template for New Presenters


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

Goal Progress–Feb 2021


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

Read the latest Blogs


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


SQL Server Q&A from the SQLServerCentral community

Get answers