Hi Folks,
I am comparing two data sets for integrity and compliance and using the keys of unique individual number identifier (primary key) along with date of admission, I am finding that between the databases sometimes the only difference is a date of admission difference between a few days, which is OK. How would I be able to write a query that would show differences between the two data sets based on unique individual number identifier and date of admission while allowing for say 5 grace days between the data sets as being counted as not a difference/mismatch?
Thank you very much for the help,
Joe
I am comparing two data sets for integrity and compliance and using the keys of unique individual number identifier (primary key) along with date of admission, I am finding that between the databases sometimes the only difference is a date of admission difference between a few days, which is OK. How would I be able to write a query that would show differences between the two data sets based on unique individual number identifier and date of admission while allowing for say 5 grace days between the data sets as being counted as not a difference/mismatch?
Thank you very much for the help,
Joe
