>>I have a stored proc that accepts three parameters - then does a whole lot of processing before doing the final select statement - which I'd like to return as a recordset to VB.
>>
>>However, the recordset is not being created in VB - I think I may have to declare the select statement as the return 'value' or something ... I've called simple SP's before that only had "select * from whatever" and the recordset was returned without a problem.
>>
>Maybe your SP returns more than one recordset? Try to run it in QA and see what it returns.

The SP only 'returns' one recordset in QA - however, within the SP there are a number of select from ... into table variables. Also, for testing purposes I have a few 'Print @Variable' statements - which do show up in the messages tab in QA - but there is only the one set of records showing up in the grid view.