SQL Used to compare records in tables
Read Time:26 Sec
I have been using this little SQL quite a bit lately. It is very handy in finding records that are in one table but not in the same table in a different environment.
SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000 EXCEPT SELECT * FROM [JDE_PRODUCTION].PRODCTL.F51000
It can also be used to do the insert of those records that are missing by adding an INSERT INTO statement.
INSERT INTO [JDE_PRODUCTION].PRODCTL.F951000 SELECT * FROM [JDE_DEVELOPMENT].TESTCTL.F951000 EXCEPT SELECT * FROM [JDE_PRODUCTION].PRODCTL.F51000
Happy
0
Sad
0
Excited
0
Sleepy
0
Angry
0
Surprise
0
Average Rating