I'm not meaning to run the entire snapshot every night ..... just the transactions .... hmmmmm .....

Thanks for the help !

If there is a main field you would want to know this on the something like this

SELECT fldIwannaC

FROM myTbl

GROUP BY fldIwannaC

HAVING COUNT(fldIwannaC) >...