A heads up on stored procedure behavior

Please let other users know how useful this tip is by rating it below. Do you have a tip or code of your own you'd like to share? Submit it here.

Some stored procedure are designed to return both a recordset and values via command arguments. In this situation the recordset must be read entirely before the output arguments are populated.