Stored procedure to return recordset and single field

[afranklin]

Hi,

I hope this isn't too stupid a question - I'm just trying to learn the best way!

If I need to get a recordset and also a single piece of data from one field for a web page (using MS SQL stored procedures and vbscript) should I:

a) run a stored procedure returning two recordsets, one of potentially many rows, one of one
b) run a single stored procedure returning one recordset and one return value?
c) run two stored procedures, one returning a recordset and the other returning whichever of a or b is the best way to return a single value!

Hope that makes sense!
Regards,
Alex.