Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Returning an OUTPUT value & some rows in a sproc

Author  Topic  Carlos Starting Member 6 Posts Posted - 2001-02-05 : 19:10:58 Hi friends I'm still having my personal battle with stored procedures. I am writing a kind of recordset paging within a sproc. It's not based on the number of rows of the table, but in a datetime field. So, page 1 will show records that are 2 days old, Page 2 will show records that are 4 days old, and so on. Now, my question! I want to know if there are records left (older records than the current ones being showed) when I'm returning the i-Page set, to show or not the "Next records" link. Is there any way to return BOTH a SELECT statement and an output value -would be a boolean, for example? Or am I forced to return it as another field, thus repeating it in each row? Thanks, Carlos