I have an Sql Server table with following data ( My data is not exactly street data , but this is the sample format)
Country State District ZIPCode Street
Note: I can take this to an excel sheet or MS Access database , A solution based on this is also fine
The current data seems to be corrupt . How can I check the data integrity . What I mean by that is - checking where it breaks the top down approach
Ideally, if you visualize it in a form with picklist , Selecting a Country from the picklist for country will show states in the country and then selecting State will show District ... then ZIPCode under District and Street under ZIPCode
How can I get the rows of corrupt data breaking this rule ?