We have a trip planned for 4th of July which has been planned for 9 months. Have a trip in October that's been finalized (reservations for the dog in the...

http://www.sqlservercentral.com/scripts/T-SQL/65739/

BUT, you should be aware of several things that affect the accuracy of the data you're using. 1 - zip codes are not rectangular, (examples:

So now I just need one task to do everything, I just need to store the mappings in my table.

Perhaps a bit sarcastic, but still....nice solution!

I can't imagine what the advantage would be to capture the markup, sounds like you should try to push the software company to strip before they store it.
Is...

Version control software would handle this much better. High-volume transactional tables will be problematic for you here.

For slowly changing data tables, you could maybe use audit tables,...

Maybe just create a report with nothing in it but the URL to your data dictionary site? Even if not redirecting, one extra click shouldn't be that bad.

I think commenting for the "why" part instead of the "what" is most important, but "what" can be important if it gives shape to your code. Jeff made the suggestion...

Three cats walk into a bar. It gets 100 million views on YouTube. Don't forget to Like and Subscribe in the comments below!