Here's what I do. Add a column (like tmpFlag TEXT 1) in your Daily table. Then do this:
UPDATE Daily SET tmpFlag = 'X' FROM Daily t1, hist t2 WHERE t1.xxx = t2.xxx AND t1.yyy = t2.yyy ...... Rows in Daily where tmpFlag is null don't have a match! Karen > 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. > >
