I just went through a conversion from one product to another. As a part of that process, records were exported via CSV and imported into another MS SQL database. Somewhere along the way, not all of the records were imported. (It was done using the vendor's import utility which was useless in troubleshooting this issue.) The question is this: I want to find all of the records in the original DB that did not make it into the new one. There are only two tables involved. We copied the original table into the new database to make it easier. So now they are both in the same DB. The original table is called DOCMASTER. The new table is called VERSIONS. I need to find all of the records in DOCMASTER that do not exist in VERSIONS. The only way I can tell is from two fields in each. DOCMASTER.DOCNUM should equal VERSIONS.DOCNUMBER And DOCMASTER.VERSION should equal VERSIONS.VERSION How can I write a query to show me every record in DOCMASTER That didn't make it into VERSIONS? I know this should be easy. I apologize in advance. Very sleep deprived at this point. Any help is appreciated. Athelene Gieseman [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
