The following T-SQL script creates a lookup table containing all the U.S. States, Territories, and DC as well as all the Canadian Provinces and Territories. This table is called Config.Region. The regions can be filter by the following group codes.