Hey Mike,
You are right, this is a much better way to do this. Sometimes you get moving forward and can't see the forest through the trees! Thanks for your help.
Kevin
>Hi Kevin
>
>If a piece of code is taking even 20 minutes, I'd be unhappy ;).
>
>Do you want to pull new data into your existing data? If so, you won't need to delete anything (implying a later process to get the undeleted records via pack or another SQL)
>
>How about flipping the entire process over?
>
>
>SELECT * ;
> FROM NEW ;
> WHERE ;
> ssn + holder_num + DTOS(date_rem) NOT IN ;
> (SELECT DISTINCT ssn + holder_num + DTOS(date_rem) FROM old) ;
> INTO CURSOR ;
> c_KeepThese
>