>candidate index on date of dayly rec and robots not thrown by error from dupliacte creation tries come to mind
>
>update: If Upsert/Merge can be made to work, it might be less code and be cleaner as it should delegate handling to the server. Upsert not in all SQL dialects might be a show stopper.

Thanks