Two problems here, one significant, one not so. The significant problem seems to be that the proc works based on the assumption that the state of the Order table...

In reference to the above, deletes have supported joins since Sybase 4.9x, prior to Microsoft ever getting involved, and it was certainly supported in SS7. As for RI, nobody...