I've loaded a few hundred XML files into a SQL Server 2008 DB and need to show that the data was accurately replicated.
I'd like to take 10% of each table (each XML files corresponds to a table) and check them against the XML file. Or vice versa, it doesn't really matter.
It is easy to select 10% of each table at random, but does anyone have an idea on how to check it against the XML files?
Thanks in advance.