ChrisCarsonSQL,

Excellent comments. I plan to apply them to this procedure.

Regards

Thanks for your reply.

I found why the exists() did not work (either StopID or RouteID can be NULL).

The '--Move record to history' is used to make an archive copy of...

I found the problem (and embarrassed I didn't check for this before). Either StopID or RouteID can be NULL. However, that brings up an interesting point. How...