Thank you so much!You Rock! if you were here in US,I'd be taking you to lunch lol!

Is it possible not to write a code in SQl and instead do it visual studio? Also, the unmatched data output needs to be in PDF file and also in charts. Any idea on this?

Thanks a lot, Sorry about the time confusion. I'll try this and I'll let you know if it works.

In addition, if the records mismatched then show it. if they matched then ignore.

Thanks for the reply guys! I have two sql tables, bank and store transactions. Unmatched data are datas/transactions that didn't match. example : table A A B C D E 100 10 11/11/2011 10:20:00 12 102 11 12/12/2012 10:23:00 12 103 12 12/13/2012 10:50:00 12 105 51 12/12/2012 10:22:00 12 106 55 12/15/2012 10:55:00 12 table B A B C D E 100 10 11/11/2011 13:20:00 12 102 11 12/12/2012 13:22:00 12 103 12 12/13/2012 13:50:00 12 105 51 12/12/2012 13:22:00 12 106 52 12/15/2012 13:55:00 12 I need to make a program that will show the unmatched record in column B. My project has about 300thou data's and also I need to adjust the time ' table A is in MT and Table B is in ET. I'm not good in explanation so if it's still too vague feel free to ask for more information... l.scott249@yahoo.com

Hi you'll. I'm a newbie C# programmer. My project is to find unmatched records of two tables in sql database. The two tables are both transactions and i need to find the discrepancies. The columns include date,time,transaction ID and amount. I'm having difficulty because the tables are not identical, meaning both tables have extra column that I don;t need to match. What tools do I need to do this project. Please help.