Hi I am trying to find missing rows of data in a Hist table that is not in our Daily table. We enter rows in the Daily table, then insert them into the Hist when we close the day. I count the # of rows in the Daily table and Hist table and after the Insert we look to see if the Hist table grows by that many rows.
For this one user it appears that some of the rows are not making it to the Hist table but trying to search through 200+ rows to compare the 2 tables makes you head spin. This is what I am using but it finds no rows, yet my calculations show we are missing some rows. edit all from tran_Daily + WHERE ( CTXT(custnum) + CTXT(date_con) + + CTXT(tr_date) + ch_code + CTXT(ch_price) + + CTXT(ptest) + cknum + CTXT(date_frm) + + CTXT(date_to) + treat_dr + inshold ) NOT IN + (SELECT ( CTXT(custnum) + CTXT(date_con) + + CTXT(tr_date) + ch_code + CTXT(ch_price) + + CTXT(ptest) + cknum + CTXT(date_frm) + + CTXT(date_to) + treat_dr + inshold) FROM tran_hist) Thanks for any suggestions Marc
