• cheers for , this i must have a play with it to see if i can use it!

    the problem is i only want the customer record ignored if it is repeated in the same load! hence just selecting row number =1 would ignore potential correct results

    though i guess i could partition by load and customer!