Validate the output of an xml file written using sql server queries to a database with the data in the databse

I have some sql queries which together are generating some xml output but the xml output is missing some transactions in the database.

I need to create a validation tool which could help me compare these output and thus find the missing transactions.

what approach can i take to do this using C#.net