THIS IS A SQL SERVER PROJECT. Unfortunately there is no "Database" option for Job Type!
Need a SQL Server script (procedure that can be run using Query Analyser) that will take related data files and merge them into one. This data is from the USPS and US Census Bureau to build a zip code database.
Here are links to the data:
[login to view URL]
[login to view URL]
The USPS data is a merge of the City State data and 5 Digit Zip data. The census data is any of the 5 files available the problem is that the census data is from 2000 so a lot of it will be out of date. Any suggestions to remedy this issue will be appreciated.
All I need is the script. I will purchase the data if and when needed.