Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Conjurer
Starting Member
30 Posts |
 Posted - 2005-11-04 : 01:49:15
|
I have a database I want to query. It is a medical billing system. I basically want to compare a list of Names and Birthdates in an Excel spreadsheet to the table of patients in the database that have that insurance type and return only the rows from the spreadsheet that don't exist in the database.This is an eligibility list, so we need to find those that don't have this insurance set up for them in our billing system and update their records.We will probably want to do the update manually so I don't mess it up too bad  , but would like to zero in on who needs the updates rather than having to look at every single record.Any ideas on how to approach this?Would this be a join, or would I need to do a select from table 1 where pt/insurance not in select pt/ins from table 2? |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-11-04 : 02:19:30
|
| Post some sample data and the result you wantMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
query to compare two tables