Here's an interesting site by NANPA, the North American Numbering Plan Association. Lot of different things concerning telephony, specifically about NPA/NXX (area code/exchange), etc.
Most interesting, fun to play with, and useful for a lot of things is the following link on that page.
Central Office Code Assignment Records
It contains all of the active NPA/NXX combinations in various files (including one larger file that contains them all), which is easy and useful for testing import methods such as BCP, Bulk Insert, SSIS, and what have you. It's not as extensive as some of the paid files available in that it doesn't contain VnH coordinates nor Lat/Lon or other geo-location information but it does contain enough simple data in a consistent format while still echoing some of the mistakes in data format the we have to contend with. For example, the files are tab delimited but the columns have been right padded to also make the files "Fixed Field" in nature. NPA/NXX are listed as NPA-NXX using dash as the delimiter instead of a tab. And, the company name isn't just right padded but it also used quoted identifiers. It's a really easy data set to understand the typical problems it contains are great for practicing.
On the first URL above, there's a good mix of zip and xls files of all shapes and sizes. If you think you know how to import and normalize Excel files, there are some really good typical examples that will test that for you. 😉
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".
"Dear Lord... I'm a DBA so please give me patience because, if you give me strength, I'm going to need bail money too!"
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)