Creating cursors to pass parameters in SQl Server 2000

[9654]

I was wondering if Sql Server has feature like oracle where you can declare cursors and declare parameters to pass to it.


I need to call a cursor in a cursor and that cursor is based on the values of the previous cursor.

So i want to declare both the cursors at the top and pass parameters to the second cursors.

In the Sql Server help it asks to declare it inside again and that is bad for performance.

 

[JayKusch]

You may be able to create and execute the inner cursor w/ the use of Dynamic SQL statement.

Thanks

J. Kusch