Hi all,
Couild u please give me solution in the "ADO NextRecordset"Fox example
mystored proc is like this

Create Procedure prSample
AS

SELECT * FROM Table1

SELECT * FROM Table2

SELECT * FROM table3

Now i loop thru the recordset

While Not ObjRs is nothing
  while Not ObjRs.eof
    rseponse.write objrs(0)
    objrs.movenext
  wend
 set objRs=ObjRs.nextRecordset
wend


"Now After looping thru all the Recordset i need to move to the first record of the first recordset"

Could anyone give the solution for this?????????

Seems like you are making 3 sql statment. the solution I can think out is put them in to array. and using for next to show the record and ofcourse set the array back to 0.