You must process each record set to completion then move to the next.