how to use multiple cursors

[maheinn]

Hi I need to retrieve data from two tables by using cursors
here i need to get data from first table and by comparing with second table data should be retrieved.
can any one help me how to use two cursors on two diff tables and retrieving

 

[jbenson001]

Do not use cursors. Simply join the tables.

 

[SQLSister]

Jbenson is right, you do NOT want to use cursors, they are performance killers and are the last resort if nothing else works. If you are not a dba, it is best that you forget about using cursors ever. Give use some sample data and sample results and we can figure out a set-based way to do you task.

"NOTHING is more important in a database than integrity." ESquared