cursor in a stored procedure

Hi,
I setup a stored procedure that writes to a file from a cursor. but it is necassary to make 3 passes thru the cursor data. do I really have to close the cusor then re open it before I can do the next loop,
 it seems if i do not close & reopen it, the other 2 passes don't write anything.

steve Received on Fri Sep 03 1999 - 04:18:19 CDT