I'm filling a business object based on a stored procedure that handles paging of data.  The business object is filled correctly but there is a section in the stored procedure to return the total record count, which is not related to the records count in the business object.

Example: I may have 100,000 records in the customer file but I am only requesting 1000 at a time. The stored procedure returnss the 1000 records into my business object and also return a total record count of 100,000 so I can display the page count.  How can I return this value to my business object when I call the stored procedure?

Thanks,

Tim