C# / SQL - Loop Script

I need a C#.NET script that will compare the data from 2 columns in 2 tables, and identify any differences (records in Table 2, that are not in Table 1). I have a Microsoft SQL 2000 database named "PC_DATABASE" which contains several hundred tables. I am trying to compare the data from several sets (pairs) of these tables, to find any differences (Table 1, Field 1 <> Table 2, Field 2). I will supply you a comma delimited (*.csv) list of tables and fields (see "[login to view URL]" attached). I believe that the SQL statement for this loop would read as follows: > SELECT {{Table_2}}.IdentificationNumber AS Expr1, {{Table_2}}.{{Field_2}} AS Expr2, {{Table_1}}.{{Field_1}} AS Expr3 > FROM {{Table_1}} RIGHT OUTER JOIN > {{Table_2}} ON {{Table_1}}.{{Field_1}} = {{Table_2}}.{{Field_2}} > WHERE ({{Table_1}}.{{Field_1}} IS NULL) > You will write a short C#.NET script that will (1) access the "PC_DATABASE" database, (2) loop through each line of the attached file building and executing the appropriate SQL statement, and (3) return a list showing any differences. If the results are null, then your program would return the table name, comma, "None" (e.g., {{Table_1}},None). If the results of the SQL query are not null, then your program should return the table name, comma, "Error" (e.g., {{Table_1}},Error). This program will run on a web server running Microsoft Server 2003 and Microsoft SQL 2000. The results can be in a *.csv file format. When you are finished, I will then need some very clear as specific written instructions expaining how to move the code, install it, and run it on my server. Please expect to spend some time in Instant Messenger answering questions and helping me walk through this process. ## Deliverables 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables): a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment. b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request. 3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement). ## Platform * Microsoft Server 2003 * Microsoft SQL Server 2000 * Microsoft C#.NET