DAta comparison in different database table

• ajoshi-918641

  Mr or Mrs. 500

  Points: 509

  More actions

  May 14, 2009 at 2:46 pm

  #131353

  Hi ,

  I need a script which will compare data in 2 database tables. i knaow RedGAte is good toolbut it compres static data. i am interested in dynamic data means in one table data is getting loaded everyday.And other table will show activity on that data.

  eg table1. PONumber Qty

  111 120

  table2: PONumber Qty

  111 75

  I want to compare for a particulat PONumber how many qty are there in table 2 and how many remained (120-75 = 45)

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738683

  More actions

  May 18, 2009 at 5:08 pm

  #996694

  Write the query as you would if they were two tables in the same database and fully qualify both tables.

  So include the database name and owner with the table. As in

  Northwin.dbo.Sales