trulyblessed
Programmer
I have 17 tables that are fairly large (8 - 12 million records each) for each month of data. Each table contains the same exact field names and data types. I need to find where there are duplicates across the 17 tables (and even within each table) based on three fields: Nabp, RxNbr and RefillSeq for 3 particular months. I need to produce a list of these duplicates.
How can I do this? I would normally merge the tables and then do a duplicate check using the having count(*) >1 syntax, but these tables are so big, there is no way to merge them into one table and have the space to store it. Any suggestions would be greatly appreciated.
Kim
How can I do this? I would normally merge the tables and then do a duplicate check using the having count(*) >1 syntax, but these tables are so big, there is no way to merge them into one table and have the space to store it. Any suggestions would be greatly appreciated.
Kim