Advertisement

07.05.2008 at 10:23AM PDT, ID: 23540834 | Points: 500
[x]
Attachment Details

Compare two tables each with (identical) multiple column Primary Key

Asked by SamB in Microsoft Visual Basic.Net, .NET

Tags: vb.net, Visual Studio 2005, Conversion from string "abc" to type 'Long' is not valid.

Hi Experts,

I need to compare two tables that both use the same multiple column primary key (columns named "G", "S" & "L").

Basically they are a master table (table1) and an updated version (table2). I want to compare and find where the updated table (table2) has had:

1) Records added
2) Records deleted
3) Alterations made to certain fields (lets say fields x & y) within existing records.

Can anyone give me an example how to do this?

Many Thanks,

SamStart Free Trial
[+][-]07.05.2008 at 09:11PM PDT, ID: 21939268

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]08.12.2008 at 09:53AM PDT, ID: 22214926

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.03.2008 at 06:35PM PDT, ID: 22383674

Experts Exchange has a courteous staff of administrators who help members get the most out of the website by means of administrative comments like this one.

Start your 7-day free trial to view this Administrative Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628