Hi,

I have a stored procedure with which i intend to return a custom recordset (by means of a cursor to VB) .. the data that i am returning consists of a large number of columns (around 300) and one record holding values for these columns .. since this data is not in a table.. how can i make a view or a table and make the call like 'open cur_ret for strQryName' which will create a cursor on this temp data.

to make this clearer

i have data in tables A and B
Table A (columns)

field1, field2, field3, ...... field300

Table B (fieldvals)

fval1, fval2, fval4, ...... fval300

How do i combine these 2 above to make a recordset that can passed back.

Thanks

TOG.