Can anyone help me get an ADO resultset back from a stored procedure that has two sql select statements? Everything works fine with only one sql statement but once I add a second statement my result set goes away. I really don't want to split this stored procedure into 2 separate procedures.

Thanks,
David