I have two identical tables in a dataset with difference in the contained data. Does anyone know of an efficent way of merging the data in the tables and map out the difference? Any hints would be greatly appreciated.
I'm writing a program that will syncronise data between an oracle db and mssql db. There is written a batch script which generate a couple of temp tables in oracle. The only way of communication to the oracle db is an odbc driver.
Is there any way to trigger the batch through the driver, or is...
I have two tables and i want to make a query that returns the difference. I have tried:
SELECT person1.*
FROM dbo.REL_IMS_PERSON person1
WHERE (NOT EXISTS(
SELECT person2.*
FROM dbo.REL_IMS_PERSON_ODS person2
WHERE person1.id = person2.id AND person1.fn = person2.fn))
This works...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.