>PMFJI... Am I correct in assessing that if someone changed the stored procedure so the tables were SELECTed in a different order (without also changing this code), you would end up retrieving the wrong table?
Yes, that's true.
... or follow my suggestion and mount the head of the first programmer to muck up the sp on a wooden spike for all to see. The rest will get the idea!
Exactly!! If your developers don't know what affect changing a Stored Proc will have on the application, then they deserve what punishment they get!!! <g>